software

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

Thanks.

EP

=IF(Date=0,quot;quot;,OFFSET(Data!$E$5,ROW(A1) 100,MATCH(G 8,Data!$F$3:$CT$3,0)))--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=539484
Try -

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

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 --
systemx
------------------------------------------------------------------------
systemx's Profile: www.excelforum.com/member.php...oamp;userid=29254
View this thread: www.excelforum.com/showthread...hreadid=539484quot;edwardpestianquot; wrote:
gt; I would like to know if I can add another IF statement to the
gt; following formula. For example IF cell H9 = quot;Dayquot; then perform
gt; the function.
gt; [....]
gt; =IF(Date=0,quot;quot;,OFFSET(Data!$E$5,ROW(A1) 100,
gt; MATCH(G8,Data!$F$3:$CT$3,0)))

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

=if(or(Date=0, H9!=quot;Dayquot;), quot;quot;, offset(...))

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

=if(and(Date=0, H9!=quot;Dayquot;), quot;quot;, offset(...))

That is, compute offset(...) if Date is non-zero __or__ H9 is quot;Dayquot;.

Hi EP,

Try:
if either Date should lt;gt; 0 or H9 should = quot;Dayquot;:
=IF(OR(Date=0,H9lt;gt;quot;Dayquot;),quot;quot;,OFFSET(Data!$E$5,ROW(A 1) 100,MATCH(G8,Data!$F$3:
$CT$3,0)))
or, if both Date should lt;gt; 0 and H9 should = quot;Dayquot;:
=IF(AND(Date=0,H9lt;gt;quot;Dayquot;),quot;quot;,OFFSET(Data!$E$5,ROW( A1) 100,MATCH(G8,Data!$F$3
:$CT$3,0)))

Cheers

quot;edwardpestianquot; gt;
wrote in message
news:edwardpestian.27dd5a_1146891001.7016@excelfor um-nospam.com...
gt;
gt; I would like to know if I can add another IF statement to the following
gt; formula. For example IF cell H9 = quot;Dayquot; then perform the function.
gt;
gt; Thanks.
gt;
gt; EP
gt;
gt; =IF(Date=0,quot;quot;,OFFSET(Data!$E$5,ROW(A1) 100,MATCH(G 8,Data!$F$3:$CT$3,0)))
gt;
gt;
gt; --
gt; edwardpestian
gt; ------------------------------------------------------------------------
gt; edwardpestian's Profile:
www.excelforum.com/member.php...oamp;userid=33809
gt; View this thread: www.excelforum.com/showthread...hreadid=539484
gt;

Ultimaly what I'm trying to do is perform this calaculation but add in
another criteria. For Example:

If G8=Date AND G9=quot;Dayquot;, then perform the following function. G8 will
remain a constant; it will alws be a date, but H9 will Change.--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=539484
I need all three sub criteria to perform the same function. Whatever
the date in G9 is, and the shift in H9 is, then perform the function to
look the data up.

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

Thannks All:EP

=IF(Date=0,quot;quot;,OFFSET(Data!$E$5,ROW(A1) 100,MATCH(G 8,Data!$F$3:$CT$3,0)))--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=539484
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 H8lt;gt;quot;Swingquot;=IF(OR(Date=0,$H$8lt;gt;quot;Dayquot;),quot;quot;,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--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=539484
Okay All, I was able to get to work using the following:

=IF($H$8=quot;Dayquot;,OFFSET(Data!$E$5,ROW($A$1) 101,MATC H($G$8,Data!$F$3:$CT$3,0)),IF($H$8=quot;Swingquot;,OFFSET( Data!$E$5,ROW($A$1) 102,MATCH($G$8,Data!$F$3:$CT$3 ,0)),IF($H$8=quot;Gravequot;,OFFSET(Data!$E$5,ROW($A$1) 10 3,MATCH($G$8,Data!$F$3:$CT$3,0)))))

Thanks for your help.

EP--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=539484Hi!

Try this:

=IF($H$8=quot;quot;,quot;quot;,OFFSET(Data!$E$5,MATCH($H$8,{quot;Dayquot;, quot;Swingquot;,quot;Gravequot;},0) 101,MATCH($G$8,Data!$F$3:$CT$3 ,0)))

Biff

quot;edwardpestianquot; gt;
wrote in message
news:edwardpestian.27dw4m_1146915601.6324@excelfor um-nospam.com...
gt;
gt; Okay All, I was able to get to work using the following:
gt;
gt; =IF($H$8=quot;Dayquot;,OFFSET(Data!$E$5,ROW($A$1) 101,MATC H($G$8,Data!$F$3:$CT$3,0)),IF($H$8=quot;Swingquot;,OFFSET( Data!$E$5,ROW($A$1) 102,MATCH($G$8,Data!$F$3:$CT$3 ,0)),IF($H$8=quot;Gravequot;,OFFSET(Data!$E$5,ROW($A$1) 10 3,MATCH($G$8,Data!$F$3:$CT$3,0)))))
gt;
gt; Thanks for your help.
gt;
gt; EP
gt;
gt;
gt; --
gt; edwardpestian
gt; ------------------------------------------------------------------------
gt; edwardpestian's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33809
gt; View this thread: www.excelforum.com/showthread...hreadid=539484
gt;

Worked great Biff. And much more eloquent than my version.

Thanks.

EP--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=539484