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.