Previous Topic Next Topic

Help on Excel Formula

Solved/Closed
teeco - 6 Apr 2010 à 05:45
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 6 Apr 2010 à 06:10
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 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
6 Apr 2010 à 06:10
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

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