Posted to microsoft.public.excel.misc

Jon

external usenet poster

Posts: 183

[newbie] if statement

I'm trying to include a conditional however, I'm getting a sort of a syntax
error:

=if((F5H5) AND (UPPER(C7) = "YES") AND (C9/C10 H9), "Yes", "No")

F5 0.80
H5 0.75
C7 Yes
C9 50000
C10 45000 C9/C10 = 1.11.
H9 0.90

Any ideas?

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
[newbie]	Jon	Excel Discussion (Misc queries)	3	March 29th 09 10:10 AM
Real Newbie newbie question	Dave	New Users to Excel	0	January 10th 07 07:55 PM
Help for a newbie... please	Nancie	Excel Worksheet Functions	2	April 21st 06 01:48 AM
Help! Newbie	tenaj	Excel Discussion (Misc queries)	7	March 22nd 06 09:18 PM
Newbie Help. Is this possible?	taltos1	Excel Discussion (Misc queries)	5	November 12th 05 04:40 PM

All times are GMT +1. The time now is 12:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us