Multiple IF in one cell
Hi
I need some assistance writing a formula with the following specifics:
“If A1 contains a value lower than 59% then return 0, and if A1 contains a value greater than 59% but lower than 75% then return 1, and if A1 contains a value greater than 74% but lower than 85% then return 2.5, and if A1 contains a value greater than 84% then return 5”
I managed to get the first 2 working =IF(AND(B12<59%), “0”, IF(AND(B12>59%, B12<75%), “1”,”0″)) but can’t seem to add the others.
Thanks for the help 🙂
Hi I need some assistance writing a formula with the following specifics: “If A1 contains a value lower than 59% then return 0, and if A1 contains a value greater than 59% but lower than 75% then return 1, and if A1 contains a value greater than 74% but lower than 85% then return 2.5, and if A1 contains a value greater than 84% then return 5” I managed to get the first 2 working =IF(AND(B12<59%), “0”, IF(AND(B12>59%, B12<75%), “1”,”0″)) but can’t seem to add the others. Thanks for the help 🙂 Read More
