View Single Post
  #9   Report Post  
Gary L Brown
 
Posts: n/a
Default

What I require is a spreadsheet which will give a value of 44 in a cell
by typing in 5/4 in another cell (its equivalent).


in Cell A1 put 5/4 which equals 1.25
in Cell B1 put the following formula...
= 1 - (A1/(A1+1))

Cell B1 will now equal .4444

HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".