Thread: Round up Formula Help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Round up Formula Help
F1 =CEILING(E1,1)-E1

"Richard" wrote:

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