Help with the Formula

[vmohan1978]

Dear All,

I am not getting proper answer , what i required please do the needful


A B C D E F G H


sL qty rate min max rate-a


2 500 57.5 57 58 57.5


3 1256 46.02 45 46.5 46.02


4 452 44.44 45 46.5 44.44


I need formula in F2

I am using formula : IF (C2<D2,C2,IF(C2>E2,E2,IF(OR(C2>D2,C2<E2,C2,O))


Thanks in advance.

 

[Hui]

Not sure about your logic but I think it should be:

=IF(C2<D2,C2,IF(C2>E2,E2,IF(OR(C2>D2,C2<E2),C2,O)))

 

[vmohan1978]

Dear Hui,


Thank you very much it worked perfectly.

This formula i am using for currency fluctation , Client is agreed to pay 1 usd = INR45 and maximum of INR46 more than 46 has to bear by contractor and less than 45 the contract has to forward the benefit to employer.

if its between 45 & 46 actual cost will be payable