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.