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

[TABLE="width: 500"]
<tbody>[TR]
[TD]400[/TD]
[TD]800[/TD]
[TD]=400/800[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD]-400[/TD]
[TD]800[/TD]
[TD]=-400/800[/TD]
[TD]-50[/TD]
[/TR]
[TR]
[TD]240[/TD]
[TD]800[/TD]
[TD]=240/800[/TD]
[TD]30%[/TD]
[/TR]
</tbody>[/TABLE]

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