I need a formula to use in a excel spreadsheet...
Cell A1 could be any number between 0 and 12.
I need the formula to reflect this in Cell B1:
If 0 Then 0
If >0 and <= 8.5 Then 8
If >8.5 and <= 9.25 Then 9
If >9.25 Then 11
I'm sure its a simple way to do this without using VBA. I guess my brain is having trouble getting going on a Monday. lol Thanks in advance!
Cell A1 could be any number between 0 and 12.
I need the formula to reflect this in Cell B1:
If 0 Then 0
If >0 and <= 8.5 Then 8
If >8.5 and <= 9.25 Then 9
If >9.25 Then 11
I'm sure its a simple way to do this without using VBA. I guess my brain is having trouble getting going on a Monday. lol Thanks in advance!