View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jamie Jamie is offline
external usenet poster
 
Posts: 191
Default IF function - with a twist!

Please help if you can.

I am using the IF function and will simplify what I need for explanation
purposes:

I have a value in A1 and a value in B1 and I want to display, in C1, the
larger of the two. The twist is that if that value is not larger than 100, I
want to display 100.

Please help if you can.

Thanks