View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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.