Creating macro
Hi,
Try this
r = Mid(Range("c1").Formula, 2)
Range("c1").Formula = "=IF(ISERROR(" & r & "),0," & r & ")"
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Jamie" wrote:
Hi,
Can anyone write a macro for me so that it takes the current formula I have
in a cell and adds a IF function and iserror fuction around it.
Here is what I would like:
Current formula =A1/B1
after running the macro I would like it to look like this:
=if(iserror(A1/B1),0,A1/B1)
Thanks for your help.
|