MS – Excel Question

Tags:
Microsoft Office
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

=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

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dmcdconsult
    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.
    40 pointsBadges:
    report
  • Calderdown
    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.
    0 pointsBadges:
    report
  • Mks3rd
    =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 ()
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following