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
|