Cell Calcuations
 

I need help. I can't quite grasp writing formulas in Excel yet. I am trying
to find the lowest dollar amount between cells A1,B1,C1 and then add that to
cell D1 with the total in cell E1. Any info would be greatly appreciated!!!!
Thanks,
Bruce D.
--
Bruce DiPaola

=min(A1:C1)+D1

"Bruce D." wrote in message
...
I need help. I can't quite grasp writing formulas in Excel yet. I am
trying
to find the lowest dollar amount between cells A1,B1,C1 and then add that
to
cell D1 with the total in cell E1. Any info would be greatly
appreciated!!!!
Thanks,
Bruce D.
--
Bruce DiPaola

The formula you need in E1 is =D1+MIN(A1:C1) - adds D1 to the lowest value
in range specified by the MIN function.

"Bruce D." wrote in message
...
I need help. I can't quite grasp writing formulas in Excel yet. I am
trying
to find the lowest dollar amount between cells A1,B1,C1 and then add that
to
cell D1 with the total in cell E1. Any info would be greatly
appreciated!!!!
Thanks,
Bruce D.
--
Bruce DiPaola

Hi Bruce

It works like this:
A cell can contain a value (number or text) OR a formula. If a cell contains
a formula, than all that thing can do is to calculate a result and display
it in this very cell. A formula can not do other things, like pushing
results to other cells, change colors, order pizza, ...

So if I understand this; you need a formula in E1 because you want the final
result there. It should looke like
=MIN(A1,B1,C1)+D1
and do pretty much what you describe I think. (Note that it treats an empty
cell as a zero dollar amount, post back if that's a problem.)

HTH. Best wishes Harald


"Bruce D." skrev i melding
...
I need help. I can't quite grasp writing formulas in Excel yet. I am
trying
to find the lowest dollar amount between cells A1,B1,C1 and then add that
to
cell D1 with the total in cell E1. Any info would be greatly
appreciated!!!!
Thanks,
Bruce D.
--
Bruce DiPaola

Hi

Try something like:
=MIN(A1,B1,C1)+D1
in cell E1

--
Andy.


"Bruce D." wrote in message
...
I need help. I can't quite grasp writing formulas in Excel yet. I am
trying
to find the lowest dollar amount between cells A1,B1,C1 and then add that
to
cell D1 with the total in cell E1. Any info would be greatly
appreciated!!!!
Thanks,
Bruce D.
--
Bruce DiPaola

Confusing. Maybe:

D1:

=MIN(A1:C1)

E1:

=SUM(A1:C1)

HTH
Jason
Atlanta, GA

-----Original Message-----
I need help. I can't quite grasp writing formulas in
Excel yet. I am trying
to find the lowest dollar amount between cells A1,B1,C1
and then add that to
cell D1 with the total in cell E1. Any info would be
greatly appreciated!!!!
Thanks,
Bruce D.
--
Bruce DiPaola
.

Type in cell E1
=MIN(A1:C1)+D1

"Bruce D." wrote:

I need help. I can't quite grasp writing formulas in Excel yet. I am trying
to find the lowest dollar amount between cells A1,B1,C1 and then add that to
cell D1 with the total in cell E1. Any info would be greatly appreciated!!!!
Thanks,
Bruce D.
--
Bruce DiPaola

Thanks Diane and Michael!!!!!

"Diane Alsing" wrote:

Type in cell E1
=MIN(A1:C1)+D1

"Bruce D." wrote:

I need help. I can't quite grasp writing formulas in Excel yet. I am trying
to find the lowest dollar amount between cells A1,B1,C1 and then add that to
cell D1 with the total in cell E1. Any info would be greatly appreciated!!!!
Thanks,
Bruce D.
--
Bruce DiPaola

Thanks to everyone who responded...

"Jason Morin" wrote:

Confusing. Maybe:

D1:

=MIN(A1:C1)

E1:

=SUM(A1:C1)

HTH
Jason
Atlanta, GA

-----Original Message-----
I need help. I can't quite grasp writing formulas in
Excel yet. I am trying
to find the lowest dollar amount between cells A1,B1,C1
and then add that to
cell D1 with the total in cell E1. Any info would be
greatly appreciated!!!!
Thanks,
Bruce D.
--
Bruce DiPaola
.