Need help with an excel formula

ChroniC · 23 Aug 2009 at 11:52

Im trying to enter a formula that calculates a starting value in currency in one cell, and calculates the difference between a second cell with a finishing value . I.e [a1]£100 [b1]150 [c1]+50
[b2]150 [b2]120 [c2]-30

the reason im struggling is its not a simple + or -, and i dont know the statements that controls if its a plus or a minus. For example i tried, and this and i didnt work
=if(a1<b1),then(a1-b1),else(a1+b1)

i dont even think excel recognises else,

Anyone know a simpler way of calculating the profit or loss from two money values. I'e googled loads with no luck. Thanks.

ChroniC · 23 Aug 2009 at 13:08

ok sorry, basically

I need a sum to calculate +/-
however the problem im having is its not a simple plus or minus equation because if the closing balance is higher than the starting balance it needs to be a + if its lower then its needs to be a minus.

make sense?

ChroniC · 23 Aug 2009 at 14:06

ChileanLlama said:
So you just want to show a "+" or "-" and possibly an "=" in column D based on starting and closing balance?

If so try this in D2 =IF(C2>B2,"+",IF(C2<B2,"-","="))

Yes but id also like the value too. As in -50 for +50 for the day.

ChroniC · 23 Aug 2009 at 14:19

oh yeah, jesus. so easy, when i had been making it soo complicated.

Thanks.