I have two columns - they look like the following:
YESNO | AMOUNT ________________ N | 13 N | 22 Y | 13
The AMOUNT column is a value output from a condition,
I would like to SUBTRACT 3 from the AMOUNT column IF the YESNO column has a value of Y and I'm just not sure how to arrange this.
Any suggestions? What sort of function should I be looking at to make this happen?