How JustAnswer Works:
  • Ask an Expert
    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
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
A new question is answered every 9 seconds

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
Submitted: 2 months ago.
Category: Microsoft Office
Expert:  George Sibiya replied 2 months ago.

Hi,

Welcome to JustAnswer and thank you for utilising our services.

I am reviewing your question and will post back shortly

Regards,

G

Expert:  George Sibiya replied 2 months ago.

please try

=IF(ISBLANK(J16),0,IF(J16="Yes",75,IF(J16="NA",0,75)))

And let me know if it works

Customer: replied 2 months ago.
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
Expert:  George Sibiya replied 2 months ago.

Ok thanks for the feedback. Justa moment

Expert:  George Sibiya replied 2 months ago.

Alright please try this nested ifs

=IF(J22="","",IF(J22="Yes",25,IF(J22="No",0,(IF(J22="NA",0,IF(ISNA(J22),0,IF(ISBLANK(J22),0,"")))))))

Expert:  George Sibiya replied 2 months ago.

I wasn't sure whether to use J16 or J22 you will advice

Customer: replied 2 months ago.
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
Expert:  George Sibiya replied 2 months ago.

Mhhh... ok let me revise it again

Expert:  George Sibiya replied 2 months ago.

So the formula should check values in J16 and J22 to decide on the value for O22 right?

Customer: replied 2 months ago.
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
Expert:  George Sibiya replied 2 months ago.

Ok thanks I'll send it whortly

Expert:  George Sibiya replied 2 months ago.

The following should be almost there

=IF(J16="","",IF(J16="Yes",IF(J22="Yes",25,IF(J22="No",0,"")),IF(J16="No",0,IF(J16="NA",0,""))))

Customer: replied 2 months ago.
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
Expert:  George Sibiya replied 2 months ago.

Ok great. Let me have a look just a sec

Expert:  George Sibiya replied 2 months ago.

So you had missed a comma in the above. It should be

=IF(J24="","",IF(J24<=8,0,IF(J24<=10,10,IF(J24<=12,20,"STOP"))))

In O24 you can have:

=IF(J16="No",0,IF(J16="NA",0,""))

Which only handles No and NA in J16

Please advice if I missed it

Customer: replied 2 months ago.
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
Expert:  George Sibiya replied 2 months ago.

Oh ok, a moment please

Expert:  George Sibiya replied 2 months ago.

Alrigth, this should work:

=IF(J24="","",IF(J16="No",0,IF(J16="NA",0,IF(J24="","",IF(J24<=8,0,IF(J24<=10,10,IF(J24<=12,20,"STOP")))))))