Sum formula not working

[karthik_kaliappan]

Hi,

I am facing a weird challenge here. I have a column in with I have ifand conditions and the corresponding result is a number. Please see the formula I am below:-

Formula 1 =IF(C16="Yes","5",IF(C16="No","0"))
Formula 2 =IF(AND(C13="Yes",D13="lessthan10mins"),"10",IF(AND(C13="Yes",D13="morethan10mins"),"5",IF(AND(C13="No",D13="NA"),"0")))

Like above a I formule from E12 until E17. I am looking to total the resulting numbers in E18 and the result here is zero. I tried format the cell to number, text....but yet it doesn't work.

Can someone please help me here?

Thanks,
Karthik

 

[Fluff]

You need to remove the quotes from around the numbers, otherwise they will be treated as text.
=IF(C16="Yes",5,IF(C16="No",0))
And do the same for the other formula

 

[ClaireS]

When you specify number arguments, DO NOT use quotes. =IF(C16="Yes",5,if(C16="No",0)) would work, for example. The way you are doing it, the numbers are text strings not actual numbers, so they have a numerical value of 0. Also, if the only options are "Yes" and "No", you can assume thate the answer is "No" if it isn't "Yes", so don't then need to specify it. If that's the case, the first formula would read =IF(C16="Yes",5,0).

 

[karthik_kaliappan]

Great, thank you very much. It worked. Appreciate the help!

 

[karthik_kaliappan]

Yeah, thank you very much. It worked. Appreciate the help!

 

[Fluff]

You're welcome & thanks for the feedback