# 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.

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

ASHRAF

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.

Ok. Thanks..

Ashraf.

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1