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

This assumes that 1000 would be 1840

=IF(B2<100,194,IF(B2999,B2*1.84,B2*1.94))

as against 999 @ 1.94 and the rest at 1.84

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kinsey" wrote in message
...
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

Bob, this works well. Many thanks!
--
kinsey


"Bob Phillips" wrote:

This assumes that 1000 would be 1840

=IF(B2<100,194,IF(B2999,B2*1.84,B2*1.94))

as against 999 @ 1.94 and the rest at 1.84

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kinsey" wrote in message
...
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