Thread: Adding up whole dollars only
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Adding up whole dollars only
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

Reply With QuoteReply With Quote