Previous Topic Next Topic

Help on Excel Formula

Solved/Closed
teeco - Apr 6, 2010 at 05:45 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 6, 2010 at 06:10 AM
I need to create a formula to give me with value and not TRUE/FALSE information. I did use the IF function, but it results in TRUE/FALSE and I need a value in the column.

Example:
In column C is the employees current salary, in column D is the amount if the employee receives a salary increase.
In column E, I want to say that if there is no increase amount in column D, Column E must show zero, but if there is an amount in Column D, the difference between Column C and Column D, must show in value. But if there is no amount in Column D, it must not show anything in Column E.

So if Column D>C = Rand value of the difference between the 2 columns.

Is it possible that you can help me with a formula?

1 reply

Answer 1 / 1
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Apr 6, 2010 at 06:10 AM
your logic is very convoluted and difficult to understand
just see whether this formula helps

=IF(D2=C2,0,IF(D2="","",D2-C2))

the logic can be made easier

if d is blank E should be blank
if d is not blank E should be D-C
-1