Think I need a MAX / MIN formula here (help needed)

  • Thread starter Thread starter Mark D
  • Start date Start date
M

Mark D

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
 
Think over your example!
Therefore this should return 2 What is this 2, it doesn't show up in the example.
Click to expand...

=IF(B2<A1,min(C2,A1),"whatif B2>=A1")

returns C2 if B2<A1 but A1 if C2>A1 (won't exceed A1) but you didn't specify
the case B2>=A1.

--
Regards!
Stefi



„Mark D†ezt írta:
 
Mark D said:
A1 = 41
B2 = 39
C2 = 6

=IF(B2<A1),C2 BUT DO NOT EXCEED A1
Therefore this should return 2
Click to expand...

You are not being clear or consistent in your requirements. Neither C2 nor
A1 is 2. Do you mean (wild-ass guess):

=max(0, min(A1-B2,C2))


----- original message -----
 
Back
Top