Confused about IF excel formula [Closed]

Question

Confused about IF excel formula [Closed]

Report

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
Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
@ in excel formula ✓ - Forum - Excel
Excel formula bar missing - How-To - Excel
Excel formula to transfer data between worksheets - How-To - Excel
Excel formula copy rows based on criteria ✓ - Forum - Excel

1 reply

Ask a question

RayH · Answer 1 · 2010-12-08T02:56:21-0500

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.

Report

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

Report

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

Confused about IF excel formula [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!