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.
Please Login or Register to view this content.Hope thats rightPlease Login or Register to view this content.
Cheers
Last edited by Philb1; 03-21-2014 at 09:23 PM.
Formula:
Please Login or Register to view this content.
Last edited by BeachRock; 03-21-2014 at 09:15 PM. Reason: Forgot about if it is nothing....
-------------
Tony
Yes it works just as I wanted. Thank-you for taking the time once again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks