More questions...
Please help me to determine the score of the following:
If Cell 13=1, score = 3 OR If Cell 13= 5 AND Cell 14 = 1, score = 2 OR If Cell 15 = 5 or DK, score = 0 OR All others, score = 1 Thanks! |
Hi
=IF(A13=1,3,IF(AND(A13=5,A14=1),2,IF(OR(A15=5,A15= "DK"),0,1))) Cheers JulieD "soxn4n04" wrote in message ... Please help me to determine the score of the following: If Cell 13=1, score = 3 OR If Cell 13= 5 AND Cell 14 = 1, score = 2 OR If Cell 15 = 5 or DK, score = 0 OR All others, score = 1 Thanks! |
All times are GMT +1. The time now is 08:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com