Displaying solutions in other cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to write a formula that will solve a specific equation, give a solution, and display a message in another cell?

For instance (and this is very basic):

a b c
$100
$200

The formula would be in column B and would solve say SUM(A1+A2)... but would then display a message in column C. Is there any formula that displays a solution or message in a cell other than the one the formula is in? Please Help! Thank you!
 
Hi 690cougar!

You'll need a formula in each cell:

B1:
=A1+B1
C1: (e.g.)
=IF(B1<>"","Projected total","")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
A formula can only return a value to its calling cell, but you could
put a formula in column C:

B1: =A1+A2
C1: =IF(B1<>0,"Yes","no")
 
Not with standard worksheet funcionality. But of course you could have a
formula in C which presents the result of the formula in B, even with text
if you require so.
Or did I misinterpret your question? Don't hesitate to post again.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

690cougar said:
Is there any way to write a formula that will solve a specific equation,
Click to expand...
give a solution, and display a message in another cell?
For instance (and this is very basic):

a b c
$100
$200

The formula would be in column B and would solve say SUM(A1+A2)... but
Click to expand...
would then display a message in column C. Is there any formula that
displays a solution or message in a cell other than the one the formula is
in? Please Help! Thank you!
 
Back
Top