To find percentage value with conditions

[angelocyrl]

Hi!

I have two values in two different cells. For example A1 = 200 and B1 = 512. Now the question is

The condition is value of B1 is >= A1 (if condition is false display '0' in the cell)
If condition is true subtract B1-A1 (512 - 200).
After subtracting I get 312 then I want to find out percentage value (8% of 312) and displayed in a cell.

Thank you in advance.

 

[Max1616]

Try this:
=IF(B1>A1,(B1-A1)*0.08,0)

 

[angelocyrl]

Hi! Max

Result comes out error.

Thanks.

 

[angelocyrl]

Hi Max

It works fine. I made a mistake.

Thanks a lot.