use this formula in cell D7
=IF(OR(B7="A",B7="B"),IF(C7<=$C$4,$B$4,IF(C7<=$C$3,$B$3,IF(C7<=$C$2,$B$2,0))),IF(C7<=$E$4,$D$4,IF(C7<=$E$3,$D$3,IF(C7<=$E$2,$D$2,0
On 12 May 2010 12:31, lucky singh wrote:
> Dear All,
>
>
> Kindly help with the IF formula in the attached sheet asap.
>
> Thanks an
Dear All,
Kindly help with the IF formula in the attached sheet asap.
Thanks an advance.
Regards,
Lucky Singh
Sr. MIS Analyst.
9987337414
--
--
Some important links for excel users:
1. Follow us on TWITTER for ti