MS – Excel Question
Hello All:
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.
Randy
Software/Hardware used:
Software/Hardware used:
ASKED:
March 9, 2005 8:04 AM
UPDATED:
March 14, 2005 3:51 PM
Answer Wiki:
=IF(ISBLANK(A5*D5),"blank",(A5*D5*Sheet2!A9))
The formula above will sense data in A5 sheet 1 and if true multiply it by cell D5 sheet 1 and then by cell A9 in sheet 2. It only works if the cell is blank. There are other "IS...." commands but I couldn't see one that handles empty cells and Nulls. Also note, if A5 is blank the equation returns a "0".
Hope this helps
Tom
To see all answers submitted to the Answer Wiki: View Answer History.
I believe problemsolver had the right idea but based on your question I think you may want this:
=IF(ISBLANK(A5),”",(D5*Sheet2!A9))
Plain English:
IF cell A5 is blank, the result is blank. If cell A5 isn’t blank, then multiply D5 by cell A9 on Sheet2.
On a slightly different tack – obviously the formulae work; but rather than use worksheet and cell references it might be advisable to define names for the cells involved – so that if the source of any of the operands eg (A29) were to change to (A30) then it would have no affect on the actual formulae.
=mouseclick in the first cell that has the value you want, enter the type of calculation,(plus, minus, *, /, etc) mouseclick on the second portion of the equation, hit enter when you have entered the the cells you want to have associated with thie equation. For order of ops enclose what is needed in quotes ()