hi all

i got a question, not sure if this is in right section (mods please move to relevant if its not)

so i got a shopping list of items and prices, i want to pay partly by card and some in cash

i got for example £7.80 on my debit card and £1.50 in cash

is there a formula or something i can use that would output/show items totally near as much to £7.80?