I am having trouble with a conditional logic issue.
We have a sell price of X and a cost of Y, resulting in a margin of Z. If the margin is greater than 27%, we would like to charge the greater of a 27% margin or $1.00. If the margin is less than 27%, we'd like to keep the margin as is. I've tried using embedded IF statements but must not be doing it right. Does anyone have any thoughts? Thanks
Bookmarks