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