| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
And, if, arguments....
I entered
=IF(B10=0,4,IF(ISBLANK(B10),0)) and it is still giving me a value of 4 when the cell in blank..... "Dave F" wrote: =IF(B7=0,4,IF(ISBLANK(B7),0)) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Chuck_in_Mo" wrote: I am trying to get a cell to do this: Look at cell B7, if B7 has a vlaue of greater than or equal to 0, return a value of 4 to cell Z4, if cell B7 is empty return a value of 0 to cell Z4.... Can you help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
And, if, arguments....
You probably need to put Dave's formula the other way round:
=IF(ISBLANK(B10),0,IF(B10=0,4,"undefined")) -- David Biddulph "Chuck_in_Mo" wrote in message ... I entered =IF(B10=0,4,IF(ISBLANK(B10),0)) and it is still giving me a value of 4 when the cell in blank..... "Dave F" wrote: =IF(B7=0,4,IF(ISBLANK(B7),0)) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Chuck_in_Mo" wrote: I am trying to get a cell to do this: Look at cell B7, if B7 has a vlaue of greater than or equal to 0, return a value of 4 to cell Z4, if cell B7 is empty return a value of 0 to cell Z4.... Can you help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
And, if, arguments....
Yes, you're right. Sorry about that. Brain's frozen!
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "David Biddulph" wrote: You probably need to put Dave's formula the other way round: =IF(ISBLANK(B10),0,IF(B10=0,4,"undefined")) -- David Biddulph "Chuck_in_Mo" wrote in message ... I entered =IF(B10=0,4,IF(ISBLANK(B10),0)) and it is still giving me a value of 4 when the cell in blank..... "Dave F" wrote: =IF(B7=0,4,IF(ISBLANK(B7),0)) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Chuck_in_Mo" wrote: I am trying to get a cell to do this: Look at cell B7, if B7 has a vlaue of greater than or equal to 0, return a value of 4 to cell Z4, if cell B7 is empty return a value of 0 to cell Z4.... Can you help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Errors on Functions with many arguments | Excel Worksheet Functions | |||
| Formulae containing more than 7 arguments? | Excel Worksheet Functions | |||
| Arguments box on form | Excel Discussion (Misc queries) | |||
| Passing Variable Number of Arguments to a Sub | Excel Discussion (Misc queries) | |||
| Excel formulas increase from 7 arguments to 12 or more | Excel Discussion (Misc queries) | |||
Hybrid Mode
