samedi 22 avril 2017

nested if help cant read statement excel

can you help me out. It can't write "moderate" or can't read the logic in the middle one where the "moderate" statement is located

=IF(CA7=0,"none",IF(CA7=1<=7,"low",IF(CA7=8<=14,"moderate",IF(CA7>=15,"high"))))

Aucun commentaire:

Enregistrer un commentaire