# What formula to use the multiplication

1. ## What formula to use the multiplication

Hi All,

This is my first thread, therefore please excuse me if i have not followed the correct rules. I would like to thank you all in advance for your help.

Would you know what formula i could use to continue the multiplication without error values.

regards,

ashraf.  Register To Reply

2. ## Re: What formula to use the multiplication

Hi Ashraf

Welcome to the forum. =IF(ISTEXT(C6),"",C6*E6) for that F6. I see that you've "paired" formulae down the column so you should be able to figure it out for the others from this formula.

Cheers

Russell  Register To Reply

3. ## Re: What formula to use the multiplication

ASHRAF  Register To Reply

4. ## Re: What formula to use the multiplication

Ok, let's go from the other angle - =IF(ISNUMBER(C3),C2*E3,"")

I'll be offline for a while now.  Register To Reply

5. ## Re: What formula to use the multiplication

Ok. Thanks..

Ashraf.  Register To Reply

6. ## Re: What formula to use the multiplication

Hi Ashraf,

I'm not sure whether I fully understand but let me know if the attached gives the correct result.

Regards

Russell  Register To Reply