The last argument of my formula below is returning a 0 when I would expect a 1. No matter what I try,
won't give me a 1. Prob something simple I'm overlooking..any help would be greatly appreciated.
=IF(H3>=5,4,(IF(AND(H3>=3,H3<5),3,(IF(AND(H3>=2,H3<3),2,(IF(AND(H3>=1,H3<2,),1,)))))))
How about this instead...
=LOOKUP(H3,{1,2,3,5},{1,2,3,4})
...but if you want to keep what you already have, a few commas out of place...
=IF(H3>=5,4,(IF(AND(H3>=3,H3<5),3,(IF(AND(H3>=2,H3<3),2,(IF(AND(H3>=1,H3<2),1)))))))
HTH
Regards, Jeff
Hi,
There is an additional comma after <2 in the last argument. Removing it, the formula works fine.
=IF(H3>=5,4,(IF(AND(H3>=3,H3<5),3,(IF(AND(H3>=2,H3<3),2,(IF(AND(H3>=1,H3<2),1,0)))))))
Another way..
=IF(H3>=5,4,IF(H3>=3,3,H3))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks