EXCEL FORMULA

Closed
gabe - Apr 15, 2010 at 03:06 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 15, 2010 at 03:18 PM


I HAVE A FORMULA THAT ADDS COLUMN A AND B AND IN COLUMN C IT ADDS COLUMN A AND B AND THEN MULTTIPLES BOTH COLUMNS BY DIFFERENT PERCENTAGES. WHAT I NEED TO DO IS HOW TO SHOW A ZERO VALUE INSTEAD OF SHOWING THE WORD VALUE

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Apr 15, 2010 at 03:18 PM
Post your formula

do this

=IF (ISERROR( your old formula here), 0, you old formula here)

when you enter your formula, leave out the leading "="
0