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

Confused about IF excel formula
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Transfer data from one excel worksheet to another automatically formula - Guide

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!