If G46 does not equal "Y", this will return a blank cell:

=IF(G46="Y",5%,"")


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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.