Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
"formula is too long" AND test for whether double-quotes are next-to text or number?? | Excel Discussion (Misc queries) | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
test for "special characters" in text | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions |