function formula how to subtract

I have a very small table and would like to subtract values in 1 column from the other.  When I choose the formula command, the dialog box opens and it the formula is saying = sum(=left).  It is adding up 3 columns together which I don't want.  I want to subract 1 column from the other.  Can anyone tell me what the forumula will be?
Answer
Answer

You can use cell references as in Excel: the top left cell is A1 etc.

For example, if you want to subtract column 3 from column 2, clear the formula proposed by the Formula dialog and replace it with =B1-C1

---
Best wishes, HansV
https://www.eileenslounge.com

17 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 30, 2025 Views 11,698 Applies to: