Thread: Round up Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
  
Posts: 709
Default Round up Formula Help
If cell E1 has, lets say $1.75 in it. Is there a way to leave E1 as it is
$1.75, BUT round it up to the nearest dollar and put the difference only .25
in cell F1.
Reply With QuoteReply With Quote