Forum Discussion

Maribro95's avatar
Maribro95
Copper Contributor
Apr 26, 2024

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...
Excel
  • NikolinoDE's avatar
    NikolinoDE
    Apr 26, 2024

    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.

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Apr 26, 2024

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.

  • Maribro95's avatar
    Maribro95
    Copper Contributor
    May 22, 2024

    NikolinoDE 

    you were super helpful and it worked!

     

    recent development in the worksheet- how would I add another argument to combine in one section?

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      May 23, 2024

      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.

       

       

    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      May 23, 2024
      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.

Resources