| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
And, if, arguments....
=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? |
| 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) | |||
Threaded Mode
