TEST FOR EXACT TEXT

P

Phil B

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.
 
A

Arvi Laanemets

Hi

In your another formula use the expression (G46="y")*0.05
(when G46 doesn't equal "y", the expression returns 0)

I.e. something like
=B46+B46*(G46="y")*0.05

Arvi Laanemets
 
K

Ken Wright

Need to be clear on your requirements, as y does not equal Y if you are
looking for an EXACT match.

If y =Y in your scenario then go with the answers you have been given, but
if you need the two differentiated, then try the EXACT() function to do your
comparison.

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

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

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
R

Ragdyer

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.).
 
R

Ragdyer

Thanks Don.

I already have "Chameleon Clock" which does exactly the same thing, but my
daughter took (borrowed, stole) my router and thought she was doing me a
favor by disabling several of my programs that automatically access the
internet.<g>
 
Top