itsmekarak
New Member
- Joined
- Sep 29, 2014
- Messages
- 30
I have a worksheet that has 4 columns: Per Piece, Hours, Extra, and Total
I am using an IF function that compares the wage earned on a per piece basis @ .25 each vs the hours+extra wage earned and then chooses which is greater.
Everything works fine with the function, however, when the entry is 0 in these columns, the function returns a "False" statement.
Is there a way to get rid of the "False" statement?
You can download the file here:
http://www.jowdy.com/uploads/Kara/If_Function_Error.zip
Thank you for your help!
I am using an IF function that compares the wage earned on a per piece basis @ .25 each vs the hours+extra wage earned and then chooses which is greater.
Everything works fine with the function, however, when the entry is 0 in these columns, the function returns a "False" statement.
Is there a way to get rid of the "False" statement?
You can download the file here:
http://www.jowdy.com/uploads/Kara/If_Function_Error.zip
Thank you for your help!