LinkBack URL
About LinkBacks
I need the following if anyone can help.
I am looking for a formula for E22.
E22 is 0 if A11 = Yes, If A11 = No or is blank E22 will =Sum(E19:E20)*.022
I need the following if anyone can help.
I am looking for a formula for E22.
E22 is 0 if A11 = Yes, If A11 = No or is blank E22 will =Sum(E19:E20)*.022
Hello Mike
If A11 is anything other than No or a blank, E22 shows 0. If A11 is No or blank it sums.If A11 is anything other than Yes, No or a blank, E22 it shows a blank. If A11 show Yes, E22 shows 0, If A11 shows No or blank, E22 sums.
=IF(OR(A11="No",A11=""),SUM(E19:E20)*22,0)Hope thats right=IF(A11="Yes",0,IF(OR(A11="No",A11=""),SUM(E19:E20)*22,""))
Cheers
Last edited by Philb1; 03-21-2014 at 09:23 PM.
Yes it works just as I wanted. Thank-you for taking the time once again
Formula:
=IF(A11="Yes",0,IF(OR(A11="",A11="No"),(SUM(E19:E20)*.022)))
Last edited by BeachRock; 03-21-2014 at 09:15 PM. Reason: Forgot about if it is nothing....
-------------
Tony
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks