Geekzone: technology news, blogs, forums
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.

22 posts


#272049 7-Jun-2020 13:43
Send private message quote this post

So, say I am selling for packages.  Each package has a different price.


You can Pay in full within 14 days or on the 20th of the following month and the 20th of the 4-month following.


I want to set up a spreadsheet that I can record this with minimal input.



Basically, all I want to do is write in the date and the name in column A and B.  Then select a programme and Pay type from drop-down boxes in C and E (this is done) Then I want it to automatically add in everything else.  So far it adds in the full amount D and the collect months 1 and 2 (not exactly how I want is as per point 1).  This is to help with work but also personal learning.


  • Make it so If I select PIF from the drop-down lists in column E, the collect months 1 and 2 (G and I columns) will automatically say PIF.  Currently, I have it as =VLOOKUP(C3,Sheet5!$A$20:$D$23,4,FALSE) in the hopes to do this with a table I had.  I had C3:D5,Sheet… so on but it only saw C3.  I could have G and I as =D/2 but prefer to also incorporate PIF not just DDs as PIF are not divided by 2 payments.



  • Make the Due date for a DD be the 20th of the following month. So, if they joined on the 27 May it would say June 20,  if they joined 4 June it would say July 20.   For the PIF it to automatically calculate 14 days from the day's date.  If I do =A4+14 that would work, but I could not put that formula into each box as some are DD.

Create new topic
1294 posts

Uber Geek


  #2500051 7-Jun-2020 14:13
Send private message quote this post

Since you want to do something if...... Have you considered the 'iif' function?

22 posts


  #2500052 7-Jun-2020 14:15
Send private message quote this post

elpenguino: Since you want to do something if...... Have you considered the 'iif' function?




I shall google iif

Create new topic

Twitter and LinkedIn »

Follow us to receive Twitter updates when new discussions are posted in our forums:

Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:

Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:

News »

Chorus completes the build and commissioning of two new core Ethernet switches
Posted 8-Jul-2020 09:48

National Institute for Health Innovation develops treatment app for gambling
Posted 6-Jul-2020 16:25

Nokia 2.3 to be available in New Zealand
Posted 6-Jul-2020 12:30

Menulog change colours as parent company merges with Dutch food delivery service
Posted 2-Jul-2020 07:53

Techweek2020 goes digital to make it easier for Kiwis to connect and learn
Posted 2-Jul-2020 07:48

Catalyst Cloud launches new Solutions Hub to support their kiwi Partners and Customers
Posted 2-Jul-2020 07:44

Microsoft to help New Zealand job seekers acquire new digital skills needed for the COVID-19 economy
Posted 2-Jul-2020 07:41

Hewlett Packard Enterprise introduces new HPE GreenLake cloud services
Posted 24-Jun-2020 08:07

New cloud data protection services from Hewlett Packard Enterprise
Posted 24-Jun-2020 07:58

Hewlett Packard Enterprise unveils HPE Ezmeral, new software portfolio and brand
Posted 24-Jun-2020 07:10

Apple reveals new developer technologies to foster the next generation of apps
Posted 23-Jun-2020 15:30

Poly introduces solutions for Microsoft Teams Rooms
Posted 23-Jun-2020 15:14

Lenovo launches new ThinkPad P Series mobile workstations
Posted 23-Jun-2020 09:17

Lenovo brings Linux certification to ThinkPad and ThinkStation Workstation portfolio
Posted 23-Jun-2020 08:56

Apple introduces new features for iPhone iOS14 and iPadOS 14
Posted 23-Jun-2020 08:28

Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.

Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.