View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heaths99
 
Posts: n/a
Default 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?