Thread: Excel Help
View Single Post
  #10  
Old 27th August 2006, 01:35 PM
Crackone Crackone is offline
Member
  
Join Date: Apr 2006
Posts: 368
Default
Quote:
Originally Posted by jfc
=DOLLAR((VALUE(A1)-1)/4+1,2)
the result is eg $4 in A1 =$1.75 if you put $5 in result is $2
Reply With Quote