Thread: Excel Help
View Single Post
  #11  
Old 27th August 2006, 09:43 PM
OZDOC OZDOC is offline
Member
  
Join Date: Jan 1970
Posts: 40
Default
Quote:
Originally Posted by Crackone
the result is eg $4 in A1 =$1.75 if you put $5 in result is $2

Why dont you just format your cells to currency?
then you only need
=(A1-1)/4+1
Reply With Quote