Posted to microsoft.public.excel.worksheet.functions

rub

external usenet poster

Posts: 21

I am having trouble with the IF function and a compound condition

I want to use the IF function to set a value of 54 if A100=369 and
B100="Gas" or A100=391 and B100="Gas". Otherwise the value should be
18.

I used =IF((A100=369 and B100="Gas") or (A100=391 and
B100="Gas"),54,18) and got an error.

I also used =IF(B100="Gas" and (A100=369 or A100=391), 54,18) and also
got an error.

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
Loan Compound Interest Function	BOBODD	Excel Worksheet Functions	2	September 19th 06 09:01 AM
Having trouble with AVG Function	[email protected]	Excel Worksheet Functions	2	August 17th 06 09:19 AM
Offset Function Trouble, Please Help	Rabbit	Excel Worksheet Functions	7	February 28th 06 12:58 AM
Date & Time	mully	New Users to Excel	4	May 23rd 05 11:56 AM
Automatically up date time in a cell	Mark	Excel Discussion (Misc queries)	5	May 12th 05 12:26 AM

All times are GMT +1. The time now is 05:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us