| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell has a value of #N/A when the formula refers to nothing
But what if A5 is not empty, but rather has something other than a number in
it including another error message??.. try: =if(iserror(2*A5),"",2*A5) if 2*A5 returns an error for any reason, make this cell empty, otherwise make it 2*A5 "Man Utd" wrote: Thank you Gord. =If(A5="","",2*A5) If A5 is empty, return nothing. If A5 has a value, return 2*A5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to create a link that refers to the cell | New Users to Excel | |||
| macro than refers to a cell? | Excel Discussion (Misc queries) | |||
| How do I keep the format of a cell that an if statment refers to? | Excel Discussion (Misc queries) | |||
| How can I keep the original value in a cell that refers to anothe. | Excel Worksheet Functions | |||
| List ranges a formula refers to | Excel Programming | |||
Threaded Mode
