View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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