TanishaS09
New Member
- Joined
- Jun 3, 2019
- Messages
- 6
Hello,
I am having problems trying to get this statement to work; specifically for the portion that is supposed to look for any numbers between 1 and 2 and then perform the calcualtion. Can someone take a look to see what I am doing incorrectly? Thanking you in advance.
=IF(B38<1,0, IF(B38=1,7.2, IF(OR(B38>1,B38<2,(7.2+((B38-1)*4.8)), IF(B38>2,12,FALSE)))))
I am having problems trying to get this statement to work; specifically for the portion that is supposed to look for any numbers between 1 and 2 and then perform the calcualtion. Can someone take a look to see what I am doing incorrectly? Thanking you in advance.
=IF(B38<1,0, IF(B38=1,7.2, IF(OR(B38>1,B38<2,(7.2+((B38-1)*4.8)), IF(B38>2,12,FALSE)))))