formula account The value of the remaining amount

[abdelfattah]

Dear brothers, the geniuses of Axel

I would like an equation on excel to give me the results as follows

Assuming that there is a cashier that holds the customer accountable in a restaurant and receives the amount and delivers the rest of the customer, how do I make an equation that gives me the amount of cash that the customer pays based on the known cash categories

-------------------------------------------------- -------------------------------------------------- -------------

For example:

If the account amount is 153 pounds

The customer will only pay 155 pounds, 160 pounds, 170 pounds, or 200



Thanks for this great forum

 

[J.Ty.]

I do not understand the question.