formula to calculate prorated percentage value in excel Solved

Question

Hello,
I need to assign a maximum amount for a purchase, this amount is prorated based on a percentage according to the purchase value.
Purchase 1000€ maximum aid 350€ or 30% = 300€
Purchase 4000€ maximum aid 350€ or 30% = 350€
How to create a formula in Excel
Thank you for your feedback.

PapyLuc51 · Answer

Hello,  the purchase in A2  in B2   =IF(A2*0.3>350,350,A2*0.3)  Best regards

ccm81 · Answer

Hello to both of you  You also have =MIN(350,A2*0.3)  Best regards

francois · Answer

Thank you very much but can you give me another formula if I want to condition this formula to a file validation.

ccm81 · Answer

It would be good to elaborate a bit more  it could look like =IF(your_condition_is_met;MIN(350;A2*0.3);"it's_your_choice)   Regards

francois · Answer

A B C D
GROSS PRICE "AMOUNT OF AID" "VALID FILE"
YES NO
5,699.00 € 350.00 € X
4,207.40 € 0.00 € X

Here are some details, the aid is conditional on the validity of the file X
hoping to be clear.
François

ccm81 · Answer

Hello  Something like this?  https://mon-partage.fr/f/gHCGby9I/  Best regards

francois · Answer

Thank you for your help best regards François

Formula to calculate prorated percentage value in excel

7 answers

Installing ubuntu on a windows 11 pc

Texture issues in enshrouded

File not found during scan. what is the procedure

Application note does not stay open on my iphone

Buying a pc for my studies

Display of an amount based on two lists?

Free time problem

Copy a youtube video on windows 11 pc

Dropdown menu and video

Varied product visuals without a shoot: what method?