karthik_kaliappan
Board Regular
- Joined
- Jun 8, 2007
- Messages
- 76
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
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