Nested IF function

  • Thread starter Thread starter picktr
  • Start date Start date
P

picktr

I think I need a nested IF function, within an IF function.

Row 5 Column E- Formula I want
Row 5 Column F- 10
Row 5 Column G- 10

Row 6 Column E- Formula I want
Row 6 Column F- 10
Row 6 Column G- 9

The first part of the formula I have
In E5- IF(F5<F6,"A","B")
In E6- IF(F6<F5,"A","B")

Formula I want:

If the numbers in F5 & F6 are equal, Then it should
evaluate the numbers in G5 & G6 to determine
"A" or "B"

Thanks,

Tom (e-mail address removed)

P.S - This is comparing two persons and numbers
that they generate on a weekly basis. An "A"
or "B" is assigned based on the lessor number.
If both are equal, the "A", "B" is determined by
the previous week
 
One way

=IF(F5<F6,"A",IF(F5=F6,IF(G5<G6,"A","B"),"B"))

and

=IF(F5>F6,"A",IF(F5=F6,IF(G5>G6,"A","B"),"B"))

what happens if F5=F6 AND G5=G6?
 
In answer to your question,
I'll have to watch carefully then adjust as necessary.

I do have a problem though.

The formula you gave me works fine,
if I create a NEW worksheet and put in the formula.

However, when I put it into the existing worksheet,
making sure all columns and rows are entered correctly,
it does not work.

Any thoughts?

To
 
Back
Top