![]() |
|
#3
|
|||
|
|||
|
with a little 'tweeking' i managed to get it working this is the final formula =IF(A2<9.99,A2*F2,IF(A2<99.99,A2*F3,IF(A2>100.01, A2*F4)))
|
| Tags |
| formulas, spreadsheets |
|
|