M
Mike B
Thanks,
But I got it by just removing some ()
=IF(Contract="John",Points*50*Quantity,IF(Contract="Willey",Points*20*Quantity,
IF(Contract="Ernst",Points*500*Quantity,IF(Contract="Rad",Points*5*Quantity,""))))
But I got it by just removing some ()
=IF(Contract="John",Points*50*Quantity,IF(Contract="Willey",Points*20*Quantity,
IF(Contract="Ernst",Points*500*Quantity,IF(Contract="Rad",Points*5*Quantity,""))))