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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get an IS and IF statement to work together in excel?
=if(isblank(cellRef),"",yourFormula)
should do it Heaths99 wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get an IS and IF statement to work together in excel?
It works - You're a genius! Thanks :)
" wrote: =if(isblank(cellRef),"",yourFormula) should do it Heaths99 wrote: 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? |
Reply |
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) |