Here's what I've come up with and I hope I am close as it's great fun to try to work this out for myself. The first section on it's own works just fine but not when I've added the second IF(AND
=IF(AND(I4>0,I4<9),"5.0-5.5","0"),IF(AND(I4=9,I4<12),"5.6-6","0"),IF(AND(I4=12,I4<15),"6.1-6.5","0")
My requirement is:
If I4 is greater than 0 but less than or = to 8 then G4 will show 5.0-5.5
If I4 is greater than 8 but less than 12 then G4 will show 5.6-6
If I4 is greater than 11 but less than 15 then G4 will show 6.1-6.5
If there is nothing in I4 then G4 will show 0
Attached is my spreadsheet unlocked (hopefully).
Bookmarks