Search : in
By :

Excel formulas

Last answer on Oct 14, 2009 11:15:09 am BST joeleene, on Oct 14, 2009 4:36:17 am BST 
 Report this message to moderators

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

Configuration: Windows XP Internet Explorer 8.0

Ask your question Reply

1

 venkat1926, on Oct 14, 2009 11:15:09 am BST

Suppose your row no. 1 is having column headings

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

   
Reply to venkat1926
Ask your question Reply
They need your help