View Single Post
  #4   Report Post  
Harald Staff
 
Posts: n/a
Default

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