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.
please see attachement
regards,
ashraf.
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
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
Thanks for your reply. also, i need formula for F3
ASHRAF
Ok, let's go from the other angle - =IF(ISNUMBER(C3),C2*E3,"")
and then copy down but adjust as per your requirements.
I'll be offline for a while now.
Last edited by Russell Dawson; 05-24-2012 at 09:46 PM. Reason: Typo
Ok. Thanks..
Ashraf.
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks