Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel cell show sum upto 500 Exceede delet without if else conditi
I actullay want to perfoam a sum in excel that give me result only up to 500.
Less than 500 sum show the real value. On the other hand just shows me 500. I have to put a formula without using " If Else Coniditions ". any one can help out. thanks budy Yasir |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel cell show sum upto 500 Exceede delet without if else conditi
Hi
You could try: =MIN(SUM(A2:A100),500) Andy. "Yasir U sman" <Yasir U wrote in message ... I actullay want to perfoam a sum in excel that give me result only up to 500. Less than 500 sum show the real value. On the other hand just shows me 500. I have to put a formula without using " If Else Coniditions ". any one can help out. thanks budy Yasir |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel cell show sum upto 500 Exceede delet without if else conditi
Try something like this:
=MIN(SUM(A1:A100),500) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Yasir U sman" <Yasir U wrote in message ... I actullay want to perfoam a sum in excel that give me result only up to 500. Less than 500 sum show the real value. On the other hand just shows me 500. I have to put a formula without using " If Else Coniditions ". any one can help out. thanks budy Yasir |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want #VALUE! to show as blank cell | Excel Worksheet Functions | |||
How do I show a tab name in an Excel cell? | Excel Discussion (Misc queries) | |||
Paste from Word table so that 1 table cell = 1 Excel cell | Excel Discussion (Misc queries) | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel |