You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

need help with choosing and using the right formula


I am trying to create a formula for the highlighted total paid cell. If someone paid this week then yes goes in the paid this week cell which will then add £2.00 to total paid. If no then nothing is added. When adding numbers to the weeks in advance column I want it to increase the total paid by increments of £2.00 for example 1 is £2.00, 2 is £4.00 etc. The opposite effect needs to happen for previous weeks owed column for example 1 is -£2.00, 2 is -£4.00 etc. Is there a formula that can make this happen? Please see photo for example. Paid this week is yes (£2.00) weeks in advance is 1 (£2.00) previous weeks owed is 0 (£0.00). So total of £4.00


Many Thanks

iPhone 16 Pro Max, iOS 18

Posted on Nov 18, 2024 7:33 AM

Reply
1 reply

need help with choosing and using the right formula

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.