Developer Forum

1. iserror and ifs nested formulas

2. Replace formula with IF(error(formula;"";formula)

Hi all

Do you think is there any macro that can change the formula in selected
range to include the IF-iserror so no error appears on the screen?

For example:
In cell A1 the formula is: =A2+B2
But if I select A1 and run the macro, It would change to:
=IF(ISERROR(A2+B2);"";(A2+B2))

I need that beacause I have a sheet with lots of formulas with different
errors and It would be quite painful to chang every formula.

Thanks you for your help!!!!

3. Commenting custom formula fields/formula on formula editor

4. My "paste special - formula" in Excel pasts values and formula?

5. Adding a formula or entering a formula?

6. To copy and paste a formula or drag a formula now only pastes the.

7. Entering a Formula; Remains a Formula Instead of Calculating

8. How to use a text formula as code formula

9. Formula in Access for Excel formula "XNPV"

10. Converting string formula to mathematical formula

11. Formula displays as formula, not as result

12. access formula for an excel formula

13. Naming a Formula, using Link to Cell containing that Formula

14. Chart ignoring formulas but only plotting formula results

15. cell shows formula...not formula result