Thread: DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
  
Posts: 347
Default 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
Reply With QuoteReply With Quote