Share via

Excel-if function

Anonymous
2022-01-24T14:16:03+00:00

Hello, I need help with a formula. I'm using Excel, in cell E5-E11, I have to calculate the total of class rings and if the got them personalized or not. If they did, I have to add 5% of the cost, if not, the price stays the same in that column. But I have to copy the if function from E5-E11. Every time I come up with a function, I'll get it right in some rows, but some are incorrect. Does anyone know the correct formula?

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-01-24T14:56:53+00:00

Hi,

Please check whether the following solution is helpful:

Formula in cell E5 is: =IF(D5="Yes",C5*1.05,C5)

- Please drag the formula down to more rows.

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-24T21:12:53+00:00

    Thank you so much!

    I am glad the solution helped.

    - I will be grateful if You please mark My response as answer and helpful.

    - This will also close this thread.

    Thank You!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-01-24T20:52:54+00:00

    Thank you so much!

    Was this answer helpful?

    0 comments