IF AND function - ExcelBanter

Posted to microsoft.public.excel.programming

GreenMonster[_2_] GreenMonster[_2_] is offline

external usenet poster

Posts: 10

IF AND function

I have the following IF AND function

=IF(AND(H250,D25="P",F25="IJ"),MIN(H25:J25)-(3/8),"")

The cell F25 can also contain "M" as a value...if so I need the function to
calculate the exact same way if "M" is choosen by the user. Do I need to
include the OR function since F25 can be either "IJ" OR "M"?

If so, I haven't been able to wrtie the function properly using OR.

Any ideas?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Excel Data Validation/Lookup function does function correcty	Kirkey	Excel Worksheet Functions	2	May 25th 09 09:22 PM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook)	[email protected]	Excel Worksheet Functions	0	September 5th 06 03:44 PM
Offset function with nested match function not finding host ss.	MKunert	Excel Worksheet Functions	1	March 21st 06 10:46 PM
Emulate Index/Match combo function w/ VBA custom function	Spencer Hutton	Excel Worksheet Functions	2	May 2nd 05 05:26 PM
Adding a custom function to the default excel function list	DonutDel	Excel Programming	3	November 21st 03 03:41 PM

All times are GMT +1. The time now is 08:38 AM.

Menu

About Us