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 = cel
A3-A4

Hope this makes sens

 

[VBA Noob]

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

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

VBA Noo

 

[martins]

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


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 confuse

 

[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 Noo