Help with a sum/formula in excel 2007

**Nuvoix** · 17th July 2011

Ive googled this one but im too cabbaged and thick to understand.

Would anybody be kind enough just to tell me what I need to enter for the sum in a perticullar cell? It wont be hard to anyone that uses Excel on a daily basis.

Ok....Here's the scenario.....

I have a value in cell C93 (for illustration this value is 217,175)
I have another value in cell C91 ( 191,696 )

The sum or formula I want in cell C94 (currently I'm using =C91-C93) is......

C91 minus C93 = C94 (-25,479) . If value in C94 is minus like in this case I would like the value in C91 turned to a positive IE 25,479. If the value in cell C94 originally is equal or greater than 1 then I need just a 0 (zero) to be viewed. Think your smart eh? lol

Plz be kind to me

**destro404** · 17th July 2011

Try this, this is what your explanation said you wanted......

Code:

=IF(C94 < 0,ABS(C91),0)

But if you take your figures as a worked example then it's actually the C94 value you want un-negatived. So you would use this instead...

Code:

=IF(C94 < 0,ABS(C94),0)

**Nuvoix** · 17th July 2011

Thanx Destro, The 2nd formula whatever it was seemed to do the trick perfectly. It just means nothing to me...its just another foreign language. Top man!!!