Ian

Posts: n/a

Help Required With IF AND Formula

Hi - I need to write an IF AND Formula which evaluates 3 values

IF VALUE1<6 and VALUE2<6 and VALUE350 the result is GREEN

I have the formula to evaluate 2 values IF(AND(VALUE1<6,VALUE2<6),"GREEN"
but how do I incorporate the third value in to this?

Many thanks
Ian

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 required!!!	Don	Excel Discussion (Misc queries)	4	February 22nd 05 08:34 PM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM
addition to my date formula...required	Juco	Excel Worksheet Functions	5	January 30th 05 11:48 AM
Rate of return required formula	Alorasdad	Excel Worksheet Functions	1	November 18th 04 03:14 AM
Price rounding - exception formula required	Alex McCourty	Excel Worksheet Functions	2	November 6th 04 08:33 AM

All times are GMT +1. The time now is 04:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us