asked on

Excel VBA - I need to multiply two cells

How can i multiply the price and qty and let it enter the value in the total column? i want it to be only one code cause i am going to use a button

Thanks,
Ahmad Abbas
2015-10-30_130541.png

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ahmad Abbas

ASKER

Sorry but like i didin't get it i want it to multiply qty and price and put them in the total column

Ahmad Abbas

ASKER

Nvm and tyvm for helping me!!!

Ahmad Abbas

ASKER

It worked

Ahmad Abbas

ASKER

Last question can u explain to me that code?

Thanks,
Ahmad Abbas

Subodh Tiwari (Neeraj)

The code looks at values in column B starting from row2 to the last cell with value in column B and if the value in a cell in column B is numeric and is not blank, it multiplies the value in column B with value in column C and places the result in column D in the corresponding row.

So if column B contains a text string or it is blank i.e. doesn't contain a qty in it, the code will overlook that cell.

Ahmad Abbas

ASKER

Thanks

Subodh Tiwari (Neeraj)

You're welcome Ahmad! Glad I could help.

Ahmad Abbas

ASKER

can i ask you for ur email or skype or anything where i can contact u if i needed help?

Subodh Tiwari (Neeraj)

Just sent you a Private Message with my Email Id.

Ahmad Abbas

ASKER

Thanks

Subodh Tiwari (Neeraj)

My Pleasure Ahmad!