Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask George Sibiya Your Own Question

George Sibiya, Computer Hardware Engineer

Category: Microsoft Office

Satisfied Customers: 220

Experience: PhD in Computer Science

94470076

Type Your Microsoft Office Question Here...

George Sibiya is online now

I have excel sheet has formula as = IF(J16=

Customer Question

Hi, I have excel sheet has formula as = IF(J16= "","",IF(OR(J16="Yes,J16="NA"),0,75)). I need to add one more formula in Cell 23 to recognize IF cell J16 = NA then make the score is 0

Sorry my mistake.The formula in O22 contains = IF(J22="","",(IF(J22="Yes,25,0)))I need to add another formula in O22 along with above to have 0 score if J22 answer is "No" and "NA"

Customer:replied 2 months ago.

Here is the screenshot of the sheet that I need to add one more code in O22 to calculate 0 if the answer in cell J16 is either No or NA

I tried that but give me blank whenever the answer is yes and still shows the score even if i changed the answer to no or na

Customer:replied 2 months ago.

Please note that O22 has already formula to Calculate the score if the answer in J22 is yes or no. What i need is to keep the formula and add one more to have 0 point instead of 25 if the answer in J16 is no or na

Right. If the answer in J16 is yes then O22 answer will be taken based on the answer from J22 and if the answer in J16 is no or NA then O22 should be 0

Thank you very much. It's work perfect with given codes. But how can it can be worked with below=IF (J24="","",IF(J24<=8,0 IF(J24<=10,10,IF(J24<=12,20,"STOP")))).I need to do same thing with previous when J16 answer is No or NA the score in O24 will be 0

This one is already in O24 =IF(J24="","",IF(J24<=8,0,IF(J24<=10,10,IF(J24<=12,20,"STOP")))) I need to do same thing with to have 0 point whenever the answer no or NA in J16