EXCEL FORMULA

Closed

gabe - Apr 15, 2010 at 03:06 PM
rizvisa1 Posts 4478 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

EXCEL FORMULA
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Transfer data from one excel worksheet to another automatically formula - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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 "="

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!