Thread: Think I need a MAX / MIN formula here (help needed)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark D[_2_] Mark D[_2_] is offline
external usenet poster
  
Posts: 52
Default Think I need a MAX / MIN formula here (help needed)
Hi Again

I need a formula that does the following

A1 = 41
B2 = 39
C2 = 6

=IF(B2<A1),C2 BUT DO NOT EXCEED A1

Therefore this should return 2

Any ideas

Thank you
Reply With QuoteReply With Quote