Thread: ROundup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Esradekan Esradekan is offline
external usenet poster
 
Posts: 86
Default ROundup

I thought I posted this but I cant find it. Apologies if this is
repeating.

But

I need a formula, for cell B1, that will roundup the figure in A1 to
the nearest $2

ie, if A1 = $22.50, the figure in B1 needs to be $24.00

Anyone got any ideas?

TIA
Esra