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

G

Guest

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leave final cell blank 2
need to subtract .50 from a cell if it is over 6.00 4
Too many IF functions 3
Excel If statement copy only if ISNumber result is yes 1
problem with formulas (2) 7
How do i make cells in one worksheet copy certain data to another 3
How do i trouble shoot an IF function 2
Returning a YES or NO if there is a value on a range of cells 0

Top