View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
John5646 John5646 is offline
external usenet poster
 
Posts: 1
Default 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