Excel formulas

[Closed]
Report
Posts
3
Registration date
Tuesday October 13, 2009
Status
Member
Last seen
October 15, 2009
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
suppose your row no. 1 is having column headings

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