Previous Topic Next Topic

Excel formulas

Closed
joeleene Posts 3 Registration date Tuesday October 13, 2009 Status Member Last seen October 15, 2009 - Oct 13, 2009 at 11:36 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 14, 2009 at 06:15 AM
Hello,
I have a spreadsheet that I am using to calculate all my staffs wages and taxes etc.

Column :-
D is Gross Wage
E is Tax (amount to take out of Gross wage)
F is Nett Wage (amount left over)
I want to take the amount of column E from the amount in column D and put that amount in column F BUT when the amount in column E is a negative number, I don't want it taken from the Column D amount at all, (in that case column D and F should be the same amount). How do I formulate this?

Thanks in Advance
Joeleene
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 14, 2009 at 06:15 AM
suppose your row no. 1 is having column headings

in F2 try tis formula
=if(D2-F2<=0,D2,D2-F2)
0

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