Need help on excel

[GeorgeKellow]

This is my question 

 

In cell B13 insert a function which calculates the Tax on the Profit if the Profit is
greater than zero but otherwise just shows a zero

 

How do I do it

 

Complete n00b

[mpsparrow]

To make it simple, A1 is the Tax, B1 is the Profit, and C1 is going to be the calculation.

 

So in A1 put the percent. In B1 put your profit in. And in C1 put the following function.

 

=IF(B1>0,A1*B1,0)

 

 

[GeorgeKellow]

4 minutes ago, mpsparrow said:

To make it simple, A1 is the Tax, B1 is the Profit, and C1 is going to be the calculation.

 

So in A1 put the percent. In B1 put your profit in. And in C1 put the following function.

 

=IF(B1>0,A1*B1,0)

 

 

 

4 minutes ago, mpsparrow said:

To make it simple, A1 is the Tax, B1 is the Profit, and C1 is going to be the calculation.

 

So in A1 put the percent. In B1 put your profit in. And in C1 put the following function.

 

=IF(B1>0,A1*B1,0)

 

 

YOU ARE A LIFE SAVER. STAND BY FOR SOME STUPID QUESTIONS