I am in need of some help with Excel. What I am trying to do is as follows:
Based on the presence of a valid value, meaning other than spaces or null, in a cell I need to perform a calculation using 2 other cells. One cell will be in the same row as the cell with the valid value while the other will be a cell in a different row, possibly on a different worksheet but within the same workbook.
Is there a way to do this?
In advance thanks to anyone who can help.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!