Me again, here you go
=IF(B1=0.8,0.9,IF(B10.3,0.5,0.1))
are you needing that to go with your other formula?
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"John Mac" wrote:

If I am averaging a set of data and only want the
answer to have the decimal place of either .1, .5, or .9 how can I round off
the answer (either up or down) to the nearest of those required decimal
places?
Thanks for any help!