| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
I am looking for a formula for excel, I am having trouble getting the right
calculation. The answer I am looking for is: if the range is less than 1300 then the answer is equal to the range, if the range is greater than 1300 then the answer is 1300. =if(range)<,"range",if(range)1300,"1300" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formulas
Try it this way:
=min(a1,1300) Regards, Fred. "Arlene" wrote in message ... I am looking for a formula for excel, I am having trouble getting the right calculation. The answer I am looking for is: if the range is less than 1300 then the answer is equal to the range, if the range is greater than 1300 then the answer is 1300. =if(range)<,"range",if(range)1300,"1300" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formulas
if the range is less than 1300 then...
if the range is greater than 1300 then... What if the range *is* 1300? See if this does what you want: =MIN(A1,1300) -- Biff Microsoft Excel MVP "Arlene" wrote in message ... I am looking for a formula for excel, I am having trouble getting the right calculation. The answer I am looking for is: if the range is less than 1300 then the answer is equal to the range, if the range is greater than 1300 then the answer is 1300. =if(range)<,"range",if(range)1300,"1300" |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formulas
Kindly clarify, whether here the word RANGE means that CELL VALUE or CELL
RANGES? TGV "Arlene" wrote: I am looking for a formula for excel, I am having trouble getting the right calculation. The answer I am looking for is: if the range is less than 1300 then the answer is equal to the range, if the range is greater than 1300 then the answer is 1300. =if(range)<,"range",if(range)1300,"1300" |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formulas
=MIN(A1,1300) -this formula worked, thank you.
"TGV" wrote: Kindly clarify, whether here the word RANGE means that CELL VALUE or CELL RANGES? TGV "Arlene" wrote: I am looking for a formula for excel, I am having trouble getting the right calculation. The answer I am looking for is: if the range is less than 1300 then the answer is equal to the range, if the range is greater than 1300 then the answer is 1300. =if(range)<,"range",if(range)1300,"1300" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
