TEST FOR EXACT TEXT
 

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.

TEST FOR EXACT TEXT
 

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

TEST FOR EXACT TEXT
 

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


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

TEST FOR EXACT TEXT
 

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 :-)
------------------------------*------------------------------*----------------




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

TEST FOR EXACT TEXT
 

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.

TEST FOR EXACT TEXT
 

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.

TEST FOR EXACT TEXT
 

http://www.worldtimeserver.com/
automatic reset each time you turn on computer

"C:\Program Files\Atomic Clock Sync\Atomic.exe"

--
Don Guillett
SalesAid Software

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

TEST FOR EXACT TEXT
 

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
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Don Guillett" wrote in message
...
http://www.worldtimeserver.com/
automatic reset each time you turn on computer

"C:\Program Files\Atomic Clock Sync\Atomic.exe"

--
Don Guillett
SalesAid Software

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

TEST FOR EXACT TEXT
 

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.