Previous Topic Next Topic

Confused about IF excel formula

Closed
Claire - 8 Dec 2010 à 02:15
 RayH - 8 Dec 2010 à 12:04
HHello

PLease can someone help me?

I have a number in column D4 and a number in coulmn F4

If that number is equal or 10 more or ten less I want it to say Same
If it is more than 10 higher i want it say increased
If it is more than 10 lower i would like it to say decreased

Would be sooooo grateful if i can get this formula to work, it will save me
hours of manual comparison!

Thank you :)
Clairey




Related:

1 response

Réponse 1 / 1
RayH
8 Dec 2010 à 02:56
=IF(F4-D4>10,"Increase",IF(D4-F4>10,"Decrease","Same"))

I think I got those the right way around. Anyway should be easy to fix if not.
Clairey
8 Dec 2010 à 04:37
HI Ray

Thank you very much for respoinding to my problem, unfortunately when i try this forumal it returns same everytime, Im not getting increasd or decreased

Thank you
Claire
RayH
8 Dec 2010 à 12:04
Don't know why. It appears to work for me. 
10		10	Same
1		20	Increase
20		1	Decrease
10		15	Same
15		10	Same
100		200	Increase
100		50	Decrease

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses