First Time poster.
Asking for a friend
After a formula or plan:
Need to enter a number of hours into one cell.
What I need is it to calculate from the input of this CELL A to generate result in CELL B:
If CELL A is between and including 0 and 7.6 it needs to display [true value entered]
If CELL A is >7.61 and < 10.61 it needs to display [true value of 7.6] + [1.5* the remainder of the difference of 10.6]
If CELL A is > 7.61 and < 16.00 it needs to display [true value of 7.6] + [3*1.5 true value] + [2.0*The remaining difference of 16]
Notes:
>16.10 needs to error
< 0.00 needs to error
best way I can explain it.
hope it makes sense.
Thanks in advance.
Bookmarks