Re: Need to have a formula to calculate the result based upon two different cell and conditions
Thank you for your response. This is to be added as Macro i suppose, i mean adding a module and add this code there. Correct me if i am wrong.
Also, it would be great to have a formula directly as i need to have this used at many different locations and this is making it complicated as i also need to train my guys down the line for these formulas that i use in my sheet to ensure correctness of data. however, i have the option of adding protection and i have done that to save the formulated columns from being changed.Also, whatever you are attaching, please attach in excel format as .qvw format is not recognised by my system and i have no option to open this extension file.