Previous Topic Next Topic

Confused about IF excel formula

Closed
Claire - Dec 8, 2010 at 02:15 AM
 RayH - Dec 8, 2010 at 12:04 PM
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




1 response

Answer 1 / 1
RayH
Dec 8, 2010 at 02:56 AM
=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
Dec 8, 2010 at 04:37 AM
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
Dec 8, 2010 at 12:04 PM
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
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses