Hello, Im currently writing a payroll sheet within excell and trying to write an IF statement to make a cell blank if referring to another blank cell but it is showing the formula is incorrect. Can anyone help with this please. Below is the following IF statement that im using;
=IF( F4 <97, AM4*0.8, IF( F4 >=97, AM4*1.1, IF( F4=" ";" "; AM4)))
Seems you switched to semicolons instead of commas at the end. Perhaps you meant:Originally Posted by JUDSON_IRELAND
=IF( F4 <97, AM4*0.8, IF( F4 >=97, AM4*1.1, IF( F4=" "," ",AM4)))
Last edited by klvaughnsd; 05-08-2014 at 11:48 AM.
i tried both, neither works
Figured out the problem its working now. thanks for the information tho
This was the solution
=IF( F4 = 0, AM4*1, IF( F4 <97, AM4*0.8, IF( F4 >=97, AM4*1.1, AM4)))
This formula :
=IF( F4="","",IF( F4 <97, AM4*0.8, IF( F4 >=97, AM4*1.1, AM4)))
appears to work. While testing it, I put in data in F4 and AM4. When I looked at results, I thought the F4 = "" needed to move up front as "" would be less than 97. But then I noticed, you were testing for a space " " instead of null ""..
Last edited by klvaughnsd; 05-08-2014 at 12:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks