SOLVED

Multiple IF in one cell

Copper Contributor

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 :)

4 Replies
best response confirmed by HansVogelaar (MVP)
Solution

Re: Multiple IF in one cell

Try this:

=IF(A1<59%,0,IF(AND(A1>59%,A1<75%),1,IF(AND(A1>74%,A1<85%),2.5,IF(A1>84%,5,""))))

Re: Multiple IF in one cell

You can try this formula =IF(A1<0.59, 0, IF(A1<0.75, 1, IF(A1<0.85, 2.5, 5)))

Re: Multiple IF in one cell

works perfectly thank you :)

Re: Multiple IF in one cell

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

Re: Multiple IF in one cell

Try this:

=IF(A1<59%,0,IF(AND(A1>59%,A1<75%),1,IF(AND(A1>74%,A1<85%),2.5,IF(A1>84%,5,""))))