Forum Discussion
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 com...
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?
If possible, please provide a demo file (without sensitive data) or a description step by step or cell by cell.
I can't cope with the pictures (eyesight, resolution, etc.) and can't edit them.
Thank you for your understanding and patience.
I can't cope with the pictures (eyesight, resolution, etc.) and can't edit them.
Thank you for your understanding and patience.
