Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with IF
I've used the following to calculate a multiplied unit cost per kilo with a
minimum charge of 194. =IF(B2<100,194,B2*1.94) Now I want to allow a lower charge of 1.84 for multiples over 999 in the same cell. I've tried (guessed!!) the following but to no avail. =IF({b2<100,194,b2*1.94},{b2999,b2*1.84}) Would appreciate any suggestions -- kinsey |