Hi,
Pretty simple question I hope, I am trying to do a SUM that I cannot make work. Could someone help me with the formula.
It is an easy sum so I need to find 20% of an invoice after the tax and Vat has been removed. so I did this sum
(ROW E - ROW I - ROW K) x 20 ÷ 100
Invoice amount ROW E
TAX ROW I
VATROW K
This just gives me a big warning sign.
any help appreciated.
Thanks
iMac, OS X Mavericks (10.9.1), 27Inch 2013, 32 GB Ram
Are you trying to "sum" three cells or are you trying to "sum" three complete rows? Or are you doing this to columns? Columns have letter designations (A, B, C, etc). Rows have number designations (1, 2, 3, etc). Cells have both, as in A2, B20, C99, and the like.
The proper syntax for adding/subtracting cells would be something like =(E1 - I1 - K1) * 20/100
But, of course, I don't know what cells you are actually trying to use.
Hi Badunit,
Sorry I totally messed up my explanation didn't I... I meant Columns not rows.
I am trying to "SUM" 3 cells that sit in three set columns and put the answer in the forth column , however I will want to replicate
this sum of three columns down selected rows
Guessing where you are putting the formula... assuming the destination cell is M2
select M2, then type (or copy and paste from here)
=(E2-I2-K2)*20/100
another way to write this is:
M2=(E2-I2-K2)*20/100
select M2, copy
select M2 thru the end of the column (or thru the selection of cells you need this formula), paste
formula help
