View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dnamertz dnamertz is offline
external usenet poster
 
Posts: 5
Default IF, but Not to Exceed

Can I add an argument to an IF statement that will result in a calculation,
but not if it exceeds a certain amount? For example, can I have an IF
statement display the result F5-F4, but if F5-F4 exceeds E5 then it will
display E5?