Re: Function for a nested if statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/01/04

Next message: Chris R. Lee: "Re: Excell can't add"
Previous message: Janet: "Re: Not sure what to use"
In reply to: kmcnelson: "Function for a nested if statement"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 1 Mar 2004 21:52:17 +0100

Hi
see your replies in Excel.misc

P.S.: please don't multipost as this scatters your answers

-- 
Regards
Frank Kabel
Frankfurt, Germany
kmcnelson wrote:
> Is there a function I could use to replace this monster:
> IF(K9>0,IF(O9>=K9,L9,IF(O9>=I9,J9,IF(O9>=G9,H9,IF
> (O9>=E9,F9,D9)))),IF(I9>0,IF(O9>=I9,J9,IF(O9>=G9,H9,IF
> (O9>=E9,F9,D9))),IF(G9>0,IF(O9>=G9,H9,IF(O9>=E9,F9,D9)),IF
> (E9>0,IF(O9>=E9,F9,D9),D9))))
> I'm trying to say "look at order size and match up with
> lot size and return price".
> TIA

Next message: Chris R. Lee: "Re: Excell can't add"
Previous message: Janet: "Re: Not sure what to use"
In reply to: kmcnelson: "Function for a nested if statement"
Messages sorted by: [ date ] [ thread ]