MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Useing two arguments to validate an IF formula

Posted by RANDY on September 26, 2001 11:30 AM

Both statments (j5>0) and (i3=true) need to be true

=IF(J5>0 & I3=TRUE,"X",0)

if one or the other is false I need the 0

Little bit of a brain fart going on here

Posted by Russell Hauf on September 26, 2001 11:34 AM

AND function


Posted by Aladin Akyurek on September 26, 2001 11:35 AM

Try: =IF(AND(I3,J5>0),"X",0).

I'm trying to solve a problem involving two variables in a data table

Here is the end result I'm looking for Yearly results using Variable A and B.

The issue is that the formula's driving the data are in Quarterly format and need to be Rolled up to Yearly Results (we can't drive the model from Yearly #'s it needs to work bottom up from quarters). The challenge is to get two formulas for variable A and B that will result in the creation of a data table.


Posted by randy on September 26, 2001 11:48 AM

Thanks.... (nt)