| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating High and Low
I am working on a spreadsheet that has ANNUAL HIGH and ANNUAL LOW columns for
an energy audit. I need to calculate across the cell which is the high and low for each customer. Is there a particular formula that I use to get these? -- Cindy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating High and Low
use MAX and MIN
e.g., =MAX(A2:A100) would return the highest number in that range. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Cindy" wrote: I am working on a spreadsheet that has ANNUAL HIGH and ANNUAL LOW columns for an energy audit. I need to calculate across the cell which is the high and low for each customer. Is there a particular formula that I use to get these? -- Cindy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating High and Low
Luke- Thank you. I found something in an earlier post just as I was getting
your reply. -- Cindy "Luke M" wrote: use MAX and MIN e.g., =MAX(A2:A100) would return the highest number in that range. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Cindy" wrote: I am working on a spreadsheet that has ANNUAL HIGH and ANNUAL LOW columns for an energy audit. I need to calculate across the cell which is the high and low for each customer. Is there a particular formula that I use to get these? -- Cindy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In col if high is 83 and low 15 how do i get high =100 and low=0 | Excel Discussion (Misc queries) | |||
| High = 4 | Excel Worksheet Functions | |||
| High = 4 take 2 | Excel Worksheet Functions | |||
| Drop 2 high and 2 low - help! | Excel Discussion (Misc queries) | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Linear Mode
