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