Share via

Need "formula"

Anonymous
2022-01-24T19:58:23+00:00

Total tuition is $3050 for full-time students taking 12 credits or more and $125 per credit hour for part-time students (taking less than 12 credits). Use a function to determine the correct tuition charges.

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-24T22:46:59+00:00

Hi Kayla,

Please kindly check if the formula below meet your requirement.

=IF(B2>=12,3050,B2*125)

Regards,

Alex Chen

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-25T13:22:04+00:00

    THANK YOU SO MUCH! I was doing to reverse and I spent too much time looking at it to try and figure it out lol Much appreciated!

    Was this answer helpful?

    0 comments