Posted to microsoft.public.excel.worksheet.functions

preyesone

external usenet poster

Posts: 7

Combining two functions

I am trying to combine the IF/And functions:
=IF(SUM(E4+F4+(G4/H4)*0.8)0.5,0.05,IF(SUM(E4+F4+(G4/H4)*0.8)0.6,0.1,IF(SUM(E4+F4+(G4/H4)*0.8)0.8,0.15,AND(J4="Yes",1))))

However it is not recognizing the And portion. No matter what the formula
total is, it should give a 1 if cell J is yes. Can someone help me?

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
combining IF OR Functions	kevan	Excel Worksheet Functions	4	November 10th 08 02:14 AM
Combining Functions	MikeM	Excel Discussion (Misc queries)	3	September 30th 08 04:52 PM
Combining IF & AND functions	Khoshravan	Excel Discussion (Misc queries)	5	October 3rd 07 12:12 AM
Combining IF OR and AND functions	andyp161	Excel Worksheet Functions	3	April 20th 06 06:05 PM
Combining functions	Steve	Excel Worksheet Functions	2	March 31st 06 05:49 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us