Cell Calcuations

[Guest]

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.

 

[Michael Malinsky]

=min(A1:C1)+D1

 

[Ben Hawkins]

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

 

[Harald Staff]

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

 

[Guest]

Hi

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

 

[Jason Morin]

Confusing. Maybe:

D1:

=MIN(A1:C1)

E1:

=SUM(A1:C1)

HTH
Jason
Atlanta, GA

 

[Guest]

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

 

[Guest]

Thanks Diane and Michael!!!!!

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

 

[Guest]

Thanks to everyone who responded...

Confusing. Maybe:

D1:

=MIN(A1:C1)

E1:

=SUM(A1:C1)

HTH
Jason
Atlanta, GA