clarification: Because I don't have the solution yet, I'm a bit stuck now. I'm going to do my best to describe the problem as accurately as possible:
I'm looking for a formula for Cell E4 from tab "jan". The formula should do the following: If on the tab "nmc" cell A3 is filled in, and there is a check mark somewhere between C3:N3 (months January to December) then put the description in cell E4, otherwise leave cell E4 empty. If there is a check mark somewhere between C3:N3 (months January to December) on tab "nmc", first check whether there has been a price increase (cell AP3) and whether it applies to the month of January (if AQ3 is checked) Otherwise display the new price (price increase) that is in cell F4 of tab "jan". I hope that I have clearly described my search for the right formula now. Op dinsdag 5 april 2022 om 16:10:58 UTC+2 schreef Alex Kikkert - Home: > Thank you for your quick reply and for thinking along on this issue. I > will certainly let you know if it will work now. > > Op dinsdag 5 april 2022 om 14:53:26 UTC+2 schreef [email protected]: > >> Thanks for that. whatever I could understand so far, you are trying to >> compare total amount in column AB with BE (for sheet 'Savings'). >> If so, Try this formula to check whether col AB is less than BE or not:- >> >> *=IF((SUMPRODUCT($AF3:$AQ3=TRUE)*$AE3)>(SUMPRODUCT($C3:$N3=TRUE)*$B3);"Price >> Increased";"No Change")* >> In case you want to add both the columns AB and AE, Try this:- >> >> *=$B3*SUMPRODUCT($C3:$N3=TRUE)+SUMPRODUCT($AF3:$AQ3=TRUE)*$AE3* >> >> >> On Tuesday, April 5, 2022 at 5:10:05 PM UTC+5:30 [email protected] >> wrote: >> >>> done: >>> >>> >>> https://docs.google.com/spreadsheets/d/1HouHgA885kCGZxpQ3sOWOfJL7scxvvp_INlJEIi8nto/edit?usp=sharing >>> >>> >>> Op dinsdag 5 april 2022 om 12:37:29 UTC+2 schreef [email protected]: >>> >>>> It would be helpful to understand the requirement If you could share >>>> the sample spreadsheet. >>>> >>>> On Tuesday, April 5, 2022 at 3:39:08 PM UTC+5:30 [email protected] >>>> wrote: >>>> >>>>> If you wish, I could share the document with you. Just let me know. :) >>>>> Op dinsdag 5 april 2022 om 12:04:11 UTC+2 schreef Alex Kikkert - Home: >>>>> >>>>>> On page two, the overview behind the months: Jan to July should be € >>>>>> 60.00 and behind Aug to Dec: € 75.00. After the formula has checked >>>>>> whether >>>>>> there has been a price increase (AB2) for a certain month (AE2:AP2) >>>>>> >>>>>> Op maandag 4 april 2022 om 17:53:12 UTC+2 schreef [email protected] >>>>>> : >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> What should be output for the given sample? >>>>>>> >>>>>>> On Sunday, April 3, 2022 at 3:05:46 PM UTC+5:30 [email protected] >>>>>>> wrote: >>>>>>> >>>>>>>> I'm working on a small cash book. I'm looking for a formula that >>>>>>>> compares two rows of checkboxes. >>>>>>>> On the left you see a magazine subscription of 60 euros per month, >>>>>>>> on the right the subscription has been increased to 75 euros per month >>>>>>>> from >>>>>>>> August. >>>>>>>> the months are in the red colored row. >>>>>>>> >>>>>>>> [image: 111.png] >>>>>>>> The formula I am looking for must first check whether the month has >>>>>>>> been checked off, the monthly subscription has increased (or >>>>>>>> decreased) in >>>>>>>> price and then this new, adjusted amount (column B and AD) must be >>>>>>>> chosen / >>>>>>>> displayed. >>>>>>>> >>>>>>>> I hope I have been able to clarify my personal search for a good >>>>>>>> formula a bit. >>>>>>>> Sorry for my poor English, luckily there is Google translation ;) >>>>>>>> >>>>>>>> Kind regards, >>>>>>>> Alex >>>>>>>> >>>>>>> -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/71494c8f-b133-4e98-a0a8-5ec010cafa04n%40googlegroups.com.
