Posted to microsoft.public.excel.misc

Kentucky Hot Brown Kentucky Hot Brown is offline

external usenet poster

Posts: 1

Assistance for the IF Function

I'm trying to test the condition of Cell A1 for either/or and B1 for
either/or and if C1 is true, display the value of D1

=(IF(OR(A1="SHIP",A1="Postal"),+IF(OR(B1="Debit",B 1="Payment"),"","",+IF(AND(C1="completed"),D1,"")* ),""))

I'm stuck! How should this be?

Thanks in advance

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
Lookup function assistance	erajim	Excel Worksheet Functions	2	December 23rd 06 05:39 AM
Need assistance with IF function when calculating dates	MMangen	Excel Worksheet Functions	6	December 20th 06 05:43 PM
If Function Assistance	Chris B.	Excel Worksheet Functions	3	September 29th 06 04:30 PM
1-2-3 @ function to Excel Assistance	CMA	Excel Worksheet Functions	8	March 20th 06 11:49 PM
Average function assistance	Larry L	Excel Discussion (Misc queries)	8	August 26th 05 07:29 PM

All times are GMT +1. The time now is 02:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us