| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste between windows in excel 2003 will not work | Excel Worksheet Functions | |||
| looking for Excel VBA work | Excel Discussion (Misc queries) | |||
| How can I verify that an Excel file will work with older versions | Excel Discussion (Misc queries) | |||
| Windows in TaskBar in Excel doesn't Work the Same as in Word | Excel Discussion (Misc queries) | |||
| Windows in TaskBar in Excel doesn't Work the Same as in Word | Excel Discussion (Misc queries) | |||
Threaded Mode
