Posted to microsoft.public.excel.misc

MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline

external usenet poster

Posts: 143

[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")

The way to do logical AND in Excel is
AND(condition1, condition2, condition3)

So maybe this will meet the need:
=IF(AND(F5H5, UPPER(C7)="YES", C9/C10H9), "Yes", "No")

Or with an error check:
=IF(C10=0, "undefined", IF(...as above...))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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 01:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us