Displaying solutions in other cells

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!
 
N

Norman Harker

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.
 
J

J.E. McGimpsey

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")
 
N

Niek Otten

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,
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top