Posted to microsoft.public.excel.worksheet.functions

Colin Hayes Colin Hayes is offline

external usenet poster

Posts: 465

Complex formula assistance please.

HI

In my helper column in K2 , I'm trying to construct a formula which
combines and satisfies these arguments:

If D2 is larger than 25 and J2 equals 1 or 11 , then put 5 , otherwise
put J2.
If D2 is larger than 25 and J2 equals 2 , then put 6 , otherwise put J2.

I've been struggling with syntax. Can anyone advise?

Grateful for any help.

Best Wishes

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
Formula Assistance	tommo	Excel Discussion (Misc queries)	3	January 14th 09 04:01 PM
Formula Assistance Please	yukon_phil	Excel Worksheet Functions	8	July 19th 06 03:53 PM
Need assistance with a formula	esmer	Excel Worksheet Functions	5	March 7th 06 10:06 PM
Formula Assistance (	MarthaMartha	Excel Worksheet Functions	2	February 15th 06 05:49 PM
Formula Assistance	DougS	Excel Worksheet Functions	1	March 29th 05 11:35 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us