Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Multiple If/And statemtn in EXCEL

Comment:

Hi all - first time poster here - been having at a multiple If AND statement in Excel that I just can't get right. There are four variables and I'm trying to combine them all in one IF statement. See below. =IF(AND(F3<0,F3<=ABS($H$1)),(G3-(G3*ABS(F3)),if(and(F3<0,F3>abs($H$1)),(G3-(G3*$H$1),if(and(F3>=0,F3<I1),(G3+(G3*F3),if(and(F3>=0,F3>$I$1),(G3+(G3*I1)))," ")

Name: Bryco
Date: May 5, 2006 at 04:13:15 Pacific

Reply:

If it is just complaining about the missing parenthesis then just add them in where they are missing. Otherwise, what problem are you having with the formula? Is it returning an error? Bryan

0

Reply:

Nevermind all...I figured it out...stupid mistake on my part. Thanks!

0

Reply:

PS, it's called a "nested if" _________________________ Embrace paranoia, they ARE out to get you!

0

Excel 2003 fill colr

Reinstalling Office and u...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I have 2 charts, and want to say if the answer is 1 in the first chart, use the vlookup function to get the answer out of the second chart. Same with if the answer in the first chart is 2. Can I do th...

Summary: Hello, I have column of numbers. I would like to replace each number according to its value. So for example my column of numbers is: 2,4,7,12,90,23,12,45,23,94,21 I want to replace according to those ...

Summary: Just wondering if there is anyway I can colour the highlighting of columns or rows i.e. when I select multiple rows and columns in excel, the selection is so faded that sometimes I can't really mak...