![]() |
|
|
|
#1
|
|||
|
|||
|
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 |
|
|