Sorry, this old box I'm on today didn't automatically switch out of daylight
saving time, so did it manually, and of course I goofed and I was 12 hours
off (A.M. - P.M.).
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ken Wright" wrote in message
...
Hi RD - is your date/clock out? - You are posting hours ahead of real
time.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*------------
----
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*------------
----


"Ragdyer" wrote in message
...
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.