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