Help with Formula

[martins]

can anyone help

I would like to return a result based on the following scenario

If cell A1 <10% return "0" or if cell A1 >10% sum would then = cell A3-A4

Hope this makes sense

[VBA Noob]

I assumed that it's less than or equal to 10%

=IF(A1<=10%,"0",A3-A4)

VBA Noob

[martins]

Thanks for the help but its not quite returning the result I was looking for - probably because I am not explaining very well - I will try again -


The result is based on 2 scenarios -

If cell A1 <10% return "0" if >10% the result would be cell A3-A4

sorry if this still confuses

[VBA Noob]

What happens if it equals 10%

[VBA Noob]

If your not worried about it matching 10% then

=IF(A1<10%,"0",A3-A4)

VBA Noob