Thread: Not More Than or Maximum in a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
  
Posts: 9,101
Default Not More Than or Maximum in a formula
You need an if statement

=if(A1 24, 24, A1)

"unknown" wrote:


Reply With QuoteReply With Quote