Posted to microsoft.public.excel.misc

DebC

external usenet poster

Posts: 39

combine formulas into 1

In the examples below, is it possible to combine the 2 formulas into one?
I need to simplify my spreadsheet if possible.

IF(M3=H1,IF(MAX(H3,H7,H11,H15,H19,H23)=MAX(H5,H9 ,H13,H17,H21,H25),1,2

IF(M4=H1,IF(MAX(h3,h7,h11,h15,h19,h23)<=MAX(h5,h9 ,h13,h17,h21,h25),2,3

Thanks very much for any help.

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
Can I combine 2 formulas?	dp	New Users to Excel	8	November 4th 08 03:24 PM
Combine 2 formulas	Ken	Excel Worksheet Functions	5	September 5th 08 10:33 AM
Combine Formulas	Dennis1188	Excel Discussion (Misc queries)	5	March 5th 07 09:34 PM
how to combine formulas to.........	gmisi	Excel Worksheet Functions	5	January 13th 07 08:47 PM
Help combine 2 formulas into 1	Robert	Excel Worksheet Functions	5	April 1st 05 08:55 AM

All times are GMT +1. The time now is 05:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us