Previous Topic Next Topic

Help on Excel Formula

Solved/Closed
teeco - Apr 6, 2010 at 05:45 AM
venkat1926 Posts 1863 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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

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
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses