I can use some assistance in writing a formula that looks at column A and if column A is populated with a "YES" then looks to the amount in column B and returns the greater of 2% of the amount in column B or $25 in column C. If Column A is not populated with a "YES" then column C should remain blank. Thank you very much for your consideration.
Bookmarks