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

[Heaths99]

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?

 

[aidan.heritage]

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

should do it

 

[Roger Govier]

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)))

 

[Heaths99]

It works - You're a genius! Thanks

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

should do it