Thread: Excel Help
View Single Post
  #9  
Old 27th August 2006, 12:59 PM
jfc jfc is offline
Member
  
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default
Quote:
Originally Posted by Crackone
Where getting close I would like to put $4 in A1 not the decimal 5.00



=DOLLAR((VALUE(A1)-1)/4+1,2)
Reply With Quote