| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add iserr or iserror to this
Trying to get rid of the #value to the cells that are not currently populated
in cells with this if statement =IF(M29-(M29*Disc),M29-(M29*Disc),M29) Any help would be great Thanks -- Neall |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I add iserr or iserror to this
Presumably, either disc or M29 contains non-numeric (or non-boolean) data.
Does the following fix the problem? =IF(ISNUMBER(M29*disc),M29-(M29*disc),M29) -- Steve "Neall" wrote in message ... Trying to get rid of the #value to the cells that are not currently populated in cells with this if statement =IF(M29-(M29*Disc),M29-(M29*Disc),M29) Any help would be great Thanks -- Neall |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I add iserr or iserror to this
Thanks for the suggestion Steve, but it wont work,
I thought this might work =IF(ISERROR(M29-(M29*Disc),M29-(M29*Disc),M29),"",M29-(M29*Disc),M29-(M29*Disc),M29) However it keeps telling me that I have to many arguments, I need these arguments included for other variables involved. Any other suggestions? Thanks in advance -- Neall "Neall" wrote: Trying to get rid of the #value to the cells that are not currently populated in cells with this if statement =IF(M29-(M29*Disc),M29-(M29*Disc),M29) Any help would be great Thanks -- Neall |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I add iserr or iserror to this
What values are in M29 and disc?
-- Steve "Neall" wrote in message ... Thanks for the suggestion Steve, but it wont work, I thought this might work =IF(ISERROR(M29-(M29*Disc),M29-(M29*Disc),M29),"",M29-(M29*Disc),M29-(M29*Disc),M29) However it keeps telling me that I have to many arguments, I need these arguments included for other variables involved. Any other suggestions? Thanks in advance -- Neall "Neall" wrote: Trying to get rid of the #value to the cells that are not currently populated in cells with this if statement =IF(M29-(M29*Disc),M29-(M29*Disc),M29) Any help would be great Thanks -- Neall |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif IsErr | Excel Worksheet Functions | |||
| ISERR | Excel Worksheet Functions | |||
| Need for ISERR and ISNA Makes formula too Long | Excel Worksheet Functions | |||
| What does this function do =+IF(ISERR(F27/G27),0,F27/G27) | Excel Worksheet Functions | |||
| ISERR | Excel Worksheet Functions | |||
Hybrid Mode
