Forum Discussion
Solved
beginner formula help
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
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.
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.
you were super helpful and it worked!
recent development in the worksheet- how would I add another argument to combine in one section?
Maribro95 I guess you need something like this:
=IF(AND(F3="Yes",H3="BPC"),J3*0.4,0)of in case you want to avoid IF, perhaps this will work for you as well.
