| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's wrong in this Eqn?
=IF(OR(TABLE!U6="",ISERROR(TABLE!U6)),"",TABLE!U6)
this is placed in a different sheet. I want this Eqn to check if the value in Cell U6 of sheet "TABLE" is blank or and error, and return blank if true. otherwise copy value. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What's wrong in this Eqn?
Raz,
Do it this way =IF(ISERROR(Table!U6),"",IF(Table!U6<"",Table!U6, "")) Mike "Raz" wrote: =IF(OR(TABLE!U6="",ISERROR(TABLE!U6)),"",TABLE!U6) this is placed in a different sheet. I want this Eqn to check if the value in Cell U6 of sheet "TABLE" is blank or and error, and return blank if true. otherwise copy value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the wrong? | Excel Worksheet Functions | |||
| What am I doing wrong | Excel Discussion (Misc queries) | |||
| What is wrong? | Excel Discussion (Misc queries) | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| What's wrong with this vb? | Excel Worksheet Functions | |||
Hybrid Mode
