Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 . |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |