Thread: Stock purchasing SS formula help needed.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
raypayette raypayette is offline
external usenet poster
  
Posts: 1
Default Stock purchasing SS formula help needed.

Supposing 2702.702703 is in cell A3
you should use =FLOOR(A3,1) that will result in 2702
that can be multiplied by 0.74 to give 1999.48


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=572563

Reply With QuoteReply With Quote