=if(g36="y",.05,0)*h36

--
Don Guillett
SalesAid Software

"Phil B" wrote in message
...
I'm trying to return a specific value if a "y" is entered in a particular
cell. For example, IF (G46) is "Y", I want to return "5%" and be able to
use
that 5% in calculation for another formula.