| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then else....
Question...
How do I write a formula in cell A1 to make this happen: If the cell A5 is blank or "0" I need Excel to return the value of cell B7. Otherwise it should be the value og A5. I know how to restrict making sure that the cell is never empty - if that makes it easyere.. Please can anyone help me? rgs Susanne |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If then else....
=IF(OR(a5="",A5=0),B7,A5)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Susanne" wrote in message ... Question... How do I write a formula in cell A1 to make this happen: If the cell A5 is blank or "0" I need Excel to return the value of cell B7. Otherwise it should be the value og A5. I know how to restrict making sure that the cell is never empty - if that makes it easyere.. Please can anyone help me? rgs Susanne |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If then else....
=IF(OR(A5=0,A5=""),B7,A5)
"Susanne" wrote: Question... How do I write a formula in cell A1 to make this happen: If the cell A5 is blank or "0" I need Excel to return the value of cell B7. Otherwise it should be the value og A5. I know how to restrict making sure that the cell is never empty - if that makes it easyere.. Please can anyone help me? rgs Susanne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
