Help on Excel Formula

Solved/Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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