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