Thread: Greater Than formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ginasucasa ginasucasa is offline
external usenet poster
  
Posts: 2
Default Greater Than formula
I'm in need of the following:
a1=9

Formula: If a1 is greater than 8, I need b1 to show 8 only. If it is less
than 8, I need it to show the amount that is less than 8.

So b1 on this should show 8.

Thanks!
Reply With QuoteReply With Quote