Thread: fractions
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default fractions

On Sat, 2 Dec 2006 11:06:00 -0800, NILELATOR
wrote:

Ron, right again works just right. I changed it to
=if(g170,round(g17/f/17*4,0)/4,"") and it gives me quarters.


Glad to help. Thanks for the feedback.


thank you, just how do you keep coming up with these??


Sometimes from reading here on this NG. Sometimes I don't know; but I've been
fooling with computers for 45 years or so. So some things have rubbed off.
--ron