Thread: DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default 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))

?

Reply With QuoteReply With Quote