If formula

Natalee · Aug 4th 2004

I want to use the if function. I am trying to run two logical tests. I have done it this way
=IF(Retail<=500,DeliveryCharge,0)*OR(Distance>=10,DeliveryCharge,0) the problem is it only works for one of the logical tests.

Will Riley · Aug 4th 2004

Hi,

Try the following

=IF(OR(Retail<=500,Distance>=10),DeliveryCharge,0)

jindon · Aug 4th 2004

Hi,

=IF(Retail<=500,DeliveryCharge,0)*OR(Distance>=10,DeliveryCharge,0)

would you like to tell us the logic?

jindon

Natalee · Aug 4th 2004

Thanks

Thanks WillR that worked. :guitar: :thanx:

Will Riley · Aug 4th 2004

No worries, welcome to Ozgrid

If formula

Participate now!

Share