| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
Ok, Im wanting to have a formula that displays a fixed mumber if the result
from my formuls is = to or than the results |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
Hi,
Maybe something like: =if(SUM(A1:A10)=100,100,SUM(A1:A100)) Hope this helps! Jean-Guy "Peter" wrote: Ok, Im wanting to have a formula that displays a fixed mumber if the result from my formuls is = to or than the results |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
pinmaster wrote...
Maybe something like: =if(SUM(A1:A10)=100,100,SUM(A1:A100)) .... If so, why not =MIN(100,SUM(A1:A10)) ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
Isn't that what I suggested in my second post???
"Harlan Grove" wrote: pinmaster wrote... Maybe something like: =if(SUM(A1:A10)=100,100,SUM(A1:A100)) .... If so, why not =MIN(100,SUM(A1:A10)) ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
Thanks guys the =MIN(2000,B4*0.3)
works great. I didn't try the other. It's great to know help is out there I might have to call on you guys again. I really appreceate the help. Peter "pinmaster" wrote: Isn't that what I suggested in my second post??? "Harlan Grove" wrote: pinmaster wrote... Maybe something like: =if(SUM(A1:A10)=100,100,SUM(A1:A100)) .... If so, why not =MIN(100,SUM(A1:A10)) ? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
pinmaster wrote...
Isn't that what I suggested in my second post??? It is, but I beat you to it. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
Hi,
What I'm trying to do is =(B4*0.3) but if this amount is or=to 2000 then display 2000 "pinmaster" wrote: Hi, Maybe something like: =if(SUM(A1:A10)=100,100,SUM(A1:A100)) Hope this helps! Jean-Guy "Peter" wrote: Ok, Im wanting to have a formula that displays a fixed mumber if the result from my formuls is = to or than the results |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
Hi,
Try: =MIN(2000,B4*0.3) HTH Jean-Guy "Peter" wrote: Hi, What I'm trying to do is =(B4*0.3) but if this amount is or=to 2000 then display 2000 "pinmaster" wrote: Hi, Maybe something like: =if(SUM(A1:A10)=100,100,SUM(A1:A100)) Hope this helps! Jean-Guy "Peter" wrote: Ok, Im wanting to have a formula that displays a fixed mumber if the result from my formuls is = to or than the results |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF in between rows | Excel Worksheet Functions | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| Formula for number of entries in colum that are greater than 2 hr | New Users to Excel | |||
| How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
| How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
Hybrid Mode
