Forum Discussion
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% ...
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,""))))
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,""))))
- works perfectly thank you 🙂
