beginner formula help

[Maribro95]

hi! 

need some help.

I am trying to create a formula that will do the following

if answered yes then will calculate a percentage of another cell to equal a total number used to calculate commission.

for example if house loan is typed yes then the overall commission is x's 40% to = net income made

[#2]

@Maribro95 

You can use the following formula to achieve what you described:

=IF(A1="Yes", B1 * 0.4, 0)

In this formula:

• Replace A1 with the cell where you type "Yes" or "No" to indicate if the house loan is taken.
• Replace B1 with the cell containing the total number used to calculate the commission.
• The formula checks if the value in cell A1 is "Yes". If it is, it multiplies the value in cell B1 by 40% (0.4) to calculate the commission. If the value in cell A1 is not "Yes", it returns 0.

Make sure to adjust the cell references (A1 and B1) according to your actual data layout.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.