Ignore negative number in a formula
I have a sheet with my inflow and outflow for a small business.
I input income in a column called 'Pay'
I then calculate my GST (tax here in canada) with this formula - Pay × 0.05
When I have outflow, I use a negative number IE: -$54.44
I would like the above formula (Pay × 0.05) to ignore any negative numbers in the Pay column.
Can you help?