Adding up whole dollars only
small point, the *1 is redundant
=IF(J10="m",INT(G10),IF(J10="a",INT(G10)*2))
and if it can only be a or m you can reduce it further
=IF(J10="m",INT(G10),INT(G10)*2)
always good to remove superfluous code <G
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Carim" wrote in message
ups.com...
Hi Mike,
Watch your multiplications ...
=IF(J10="m",INT(G10*1),IF(J10="a",INT(G10*2)))
should be
=IF(J10="m",INT(G10)*1,IF(J10="a",INT(G10)*2))
HTH
Cheers
Carim
|