Can I add an IF statement

  • Thread starter Thread starter edwardpestian
  • Start date Start date
E

edwardpestian

I would like to know if I can add another IF statement to the following
formula. For example IF cell H9 = "Day" then perform the function.

Thanks.

EP

=IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1)+100,MATCH(G8,Data!$F$3:$CT$3,0)))
 
Try -

=IF(H9="Day",IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1)+100,MATCH(G
8,Data!$F$3:$CT$3,0))),"What to do if H9 does not equal Day")

That should work.

You can 'nest' up to 7 IF statements in one formula - after that it can
get a little more complicated. :)

Regards,

Rob :)
 
edwardpestian said:
I would like to know if I can add another IF statement to the
following formula. For example IF cell H9 = "Day" then perform
the function.
[....]
=IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1)+100,
MATCH(G8,Data!$F$3:$CT$3,0)))
Click to expand...

The short answer is: yes. But your intended logic is not clear.
The following might what you really want:

=if(or(Date=0, H9!="Day"), "", offset(...))

In other words, compute offset(...) only if Date is non-zero __and__
H9 is "Day". Alternatively, the following might be what you want:

=if(and(Date=0, H9!="Day"), "", offset(...))

That is, compute offset(...) if Date is non-zero __or__ H9 is "Day".
 
Hi EP,

Try:
if either Date should <> 0 or H9 should = "Day":
=IF(OR(Date=0,H9<>"Day"),"",OFFSET(Data!$E$5,ROW(A1)+100,MATCH(G8,Data!$F$3:
$CT$3,0)))
or, if both Date should <> 0 and H9 should = "Day":
=IF(AND(Date=0,H9<>"Day"),"",OFFSET(Data!$E$5,ROW(A1)+100,MATCH(G8,Data!$F$3
:$CT$3,0)))

Cheers

"edwardpestian" <[email protected]>
wrote in message
news:[email protected]...
 
Ultimaly what I'm trying to do is perform this calaculation but add in
another criteria. For Example:

If G8=Date AND G9="Day", then perform the following function. G8 will
remain a constant; it will alws be a date, but H9 will Change.
 
I need all three sub criteria to perform the same function. Whateve
the date in G9 is, and the shift in H9 is, then perform the function t
look the data up.

THe function works properly when I have it pull data based on the dat
(g9); but I cannot get it to work with the second critera.

Thannks All:EP

=IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1)+100,MATCH(G8,Data!$F$3:$CT$3,0))
 
Okay, so I've got the above formula below working as needed; but I need
to add to it.

I need it to perform the same OFFSET function, except with a change to
the range. I need it to calculate based off of (A1)+101 IF H8<>"Swing"


=IF(OR(Date=0,$H$8<>"Day"),"",OFFSET(Data!$E$5,ROW($A$1)+101,MATCH($G$8,Data!$F$3:$CT$3,0)))

I'm stuck on this one for days...

Thanks in advance for any help or feedback.

EP
 
Okay All, I was able to get to work using the following:

=IF($H$8="Day",OFFSET(Data!$E$5,ROW($A$1)+101,MATCH($G$8,Data!$F$3:$CT$3,0)),IF($H$8="Swing",OFFSET(Data!$E$5,ROW($A$1)+102,MATCH($G$8,Data!$F$3:$CT$3,0)),IF($H$8="Grave",OFFSET(Data!$E$5,ROW($A$1)+103,MATCH($G$8,Data!$F$3:$CT$3,0)))))

Thanks for your help.

E
 
Back
Top