View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KateZed KateZed is offline
external usenet poster
 
Posts: 1
Default need help with if statement that calculate minimum figure

I am trying to calualate an if statement which if false returns a figure, but
i want that figure if under a certain amount to return a minimum figure.

Eg. If a2 = yes then return $5 if no or unknown then return A4*A5 but with a
minimum of $5