Thread
:
TEST FOR EXACT TEXT
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett