How do I get an IS and IF statement to work together in excel?
 

I only want the formula below to give the True value if the logical value
cells are not blank. If the logical value cells are blank, I don't want it
to apply the formula.

=IF('Master Sheet'!I4='Master Sheet'!G4,"Draw",IF('Master Sheet'!I4'Master
Sheet'!G4,'Master Sheet'!H4,IF('Master Sheet'!I4<'Master Sheet'!G4,'Master
Sheet'!F4)))


I have tried adding ISVALUE or ISNA (see below), but that just gives me a
'false' result when I want a blank result.

=ISNA(IF('Master Sheet'!I5='Master Sheet'!G5,J6,IF('Master Sheet'!I5'Master
Sheet'!G5,'Master Sheet'!H5,IF('Master Sheet'!I5<'Master Sheet'!G5,'Master
Sheet'!F5))))

I think the problem is that I want a True, False or Other option!

Is there another way around this?

How do I get an IS and IF statement to work together in excel?
 

=if(isblank(cellRef),"",yourFormula)

should do it
Heaths99 wrote:
I only want the formula below to give the True value if the logical value
cells are not blank. If the logical value cells are blank, I don't want it
to apply the formula.

=IF('Master Sheet'!I4='Master Sheet'!G4,"Draw",IF('Master Sheet'!I4'Master
Sheet'!G4,'Master Sheet'!H4,IF('Master Sheet'!I4<'Master Sheet'!G4,'Master
Sheet'!F4)))


I have tried adding ISVALUE or ISNA (see below), but that just gives me a
'false' result when I want a blank result.

=ISNA(IF('Master Sheet'!I5='Master Sheet'!G5,J6,IF('Master Sheet'!I5'Master
Sheet'!G5,'Master Sheet'!H5,IF('Master Sheet'!I5<'Master Sheet'!G5,'Master
Sheet'!F5))))

I think the problem is that I want a True, False or Other option!

Is there another way around this?

How do I get an IS and IF statement to work together in excel?
 

Hi
Maybe

=IF(AND('Master Sheet'!I4="",'Master Sheet'!G4,"=""),"",
IF('Master Sheet'!I4='Master Sheet'!G4,"Draw",
IF('Master Sheet'!I4'Master Sheet'!G4,'Master Sheet'!H4,
IF('Master Sheet'!I4<'Master Sheet'!G4,'Master Sheet'!F4)))


--
Regards

Roger Govier


"Heaths99" wrote in message
...
I only want the formula below to give the True value if the logical
value
cells are not blank. If the logical value cells are blank, I don't
want it
to apply the formula.

=IF('Master Sheet'!I4='Master Sheet'!G4,"Draw",IF('Master
Sheet'!I4'Master
Sheet'!G4,'Master Sheet'!H4,IF('Master Sheet'!I4<'Master
Sheet'!G4,'Master
Sheet'!F4)))


I have tried adding ISVALUE or ISNA (see below), but that just gives
me a
'false' result when I want a blank result.

=ISNA(IF('Master Sheet'!I5='Master Sheet'!G5,J6,IF('Master
Sheet'!I5'Master
Sheet'!G5,'Master Sheet'!H5,IF('Master Sheet'!I5<'Master
Sheet'!G5,'Master
Sheet'!F5))))

I think the problem is that I want a True, False or Other option!

Is there another way around this?

How do I get an IS and IF statement to work together in excel?
 

It works - You're a genius! Thanks :)

" wrote:

=if(isblank(cellRef),"",yourFormula)

should do it
Heaths99 wrote:
I only want the formula below to give the True value if the logical value
cells are not blank. If the logical value cells are blank, I don't want it
to apply the formula.

=IF('Master Sheet'!I4='Master Sheet'!G4,"Draw",IF('Master Sheet'!I4'Master
Sheet'!G4,'Master Sheet'!H4,IF('Master Sheet'!I4<'Master Sheet'!G4,'Master
Sheet'!F4)))


I have tried adding ISVALUE or ISNA (see below), but that just gives me a
'false' result when I want a blank result.

=ISNA(IF('Master Sheet'!I5='Master Sheet'!G5,J6,IF('Master Sheet'!I5'Master
Sheet'!G5,'Master Sheet'!H5,IF('Master Sheet'!I5<'Master Sheet'!G5,'Master
Sheet'!F5))))

I think the problem is that I want a True, False or Other option!

Is there another way around this?