Help with Formula
 

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


--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=562128

Help with Formula
 

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

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562128

Help with Formula
 

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


--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=562128

Help with Formula
 

What happens if it equals 10%


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562128

Help with Formula
 

If your not worried about it matching 10% then

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562128