if formula to display value if condition is met

[ranjanagarwal]

I am trying to create a formula where if the condition of a cell is met then it displays the content of the cell instead of True/False.

For example

400	800	=400/800	50%
-400	800	=-400/800	-50
240	800	=240/800	30%

<tbody>
</tbody>

The formula should display the actual percentage if the value of the cell is " = or more" than +-50%..
Please help.
Thanks

 

[Trebor76]

Hi ranjanagarwal,

Welcome to MrExcel!!

Try this where 400 is in cell A2 and 800 is in cell B2 (change to suit):

=IF(OR(A2/B2>=0.5,A2/B2<=-0.5),A2/B2,"")

Regards,

Robert