Help with IF

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kinsey - 30 Sep 2007 08:41 GMT

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},{b2>999,b2*1.84})

Would appreciate any suggestions

Signature

kinsey

Reply to this Message

Bob Phillips - 30 Sep 2007 09:12 GMT

This assumes that 1000 would be 1840

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

as against 999 @ 1.94 and the rest at 1.84

Signature

HTH

Bob

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

> I've used the following to calculate a multiplied unit cost per kilo with
> a
[quoted text clipped - 8 lines]
>
> Would appreciate any suggestions

Reply to this Message

kinsey - 30 Sep 2007 09:28 GMT

Bob, this works well. Many thanks!

Signature

kinsey

> This assumes that 1000 would be 1840
>
[quoted text clipped - 14 lines]
> >
> > Would appreciate any suggestions

Reply to this Message

Rate this thread: