formula up to a maximum of 100, no greater than
 

My spreadsheet uses formulae to work out value, but our fees, or A3, is
capped at 900. So, with a formula of
A3=A1*A2
where the values are
10*100, I need A3 to be 900
but if the value is
8*100, I need A3 to be 800

formula up to a maximum of 100, no greater than
 

=IF(OR(A1="",A2=""),"",MIN(900,A1*A2))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"John5646" wrote in message
...
My spreadsheet uses formulae to work out value, but our fees, or A3, is
capped at 900. So, with a formula of
A3=A1*A2
where the values are
10*100, I need A3 to be 900
but if the value is
8*100, I need A3 to be 800