• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Do if conditions met in Excel VBA

saamrat

Member
Hello,
If there is a value in Custom, Special Rate Should be Custom. If Custom field is blank, Special Rate should be Price 2. How to do this in excel VBA
Please Help.

Special RatePrice 1Price 2Custom
91089
5105
7107
 

vletm

Excel Ninja
saamrat
Where do You would like to get the result in above ... table?
You should upload a sample file which has sample data and needed correct results.
 

saamrat

Member
Thank you for your response.
Kindly find the attached Sample Sheet.
If Column H has value, then column B Should be the value of H. Otherwise, Column B value must be of Column G. I input the formula in the cells.
Similarly, if there is a value in Column A, then Column C must be A*B. Otherwise, Column C is Blank.
Appreciate your help
 

Attachments

saamrat

Member
Wow!! you are a life saver Sir. As I am expected.
But there is a problem. If there a value already entered in the column A and if you try to change the value in column H, the multiplication in Column C is not happening. Kindly help.
 
Top