| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
value error
IF(U4="","",IF(U4<'MDA Portfolio Summary'!H3,('MDA Portfolio Summary'!H3-MDA
Portfolio Summary'!G3)*(K4:K39),IF(U4'MDA Portfolio Summary'!J3,('MDA Portfolio Summary'!G3-'MDA Portfolio Summary'!J3)*(K4:K39),""))) i am trying to have the difference of H3 and G3 if it is lower or higher, but i get a value error not sure what is wrong thanks anyone |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| ERROR | Excel Discussion (Misc queries) | |||
| Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Threaded Mode
