Posted to microsoft.public.excel.programming

Squid[_2_] Squid[_2_] is offline

external usenet poster

Posts: 17

Working with quotes

In a conditional statement, I need to code a formula that
contains quotes. I am having problems. How should I
code the following?

If Dues < 0# Then
Worksheets("Settlement").Range("I35").Value = Dues
Else
Worksheets("Settlement").Range("I35").Value = _
=IF(N39="W",ROUND(H39*$H$27,2),IF(N39="G",ROUND
(H39*$C$27,2),ROUND(H39*$F$27,2)))
End If

Thanks
Mike

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MSN Stock Quotes not working	tom_k	Excel Worksheet Functions	0	December 22nd 09 02:19 AM
change straight quotes to curly quotes	callico	Excel Discussion (Misc queries)	2	June 22nd 07 10:23 PM
Yahoo historical quotes quit working with web query	Roy	Excel Discussion (Misc queries)	0	July 22nd 06 10:30 PM
How do i get historical stock quotes using MSN Money Stock Quotes	Ash	Excel Discussion (Misc queries)	0	May 11th 06 03:26 AM
Using CSV and quotes	Neil	Excel Discussion (Misc queries)	4	October 31st 05 07:59 PM

All times are GMT +1. The time now is 07:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us