See if this works for F4, *=IF((nmc!$AP3>nmc!B3)*((SUMPRODUCT(nmc!$AQ3:$BB3=TRUE)>0))*((SUMPRODUCT(nmc!$C3:$N3=TRUE)>0));nmc!$AP3;nmc!$B3)* On Friday, April 8, 2022 at 2:53:05 PM UTC+5:30 alexk...@gmail.com wrote:
> This part works and i'm very happy with it : > > Try below formula in *Jan<E4* (checks A3 has a text + C3:N3 has any > checkmark ,Then displays *"Has Text & Has CheckMark* " else leave blank). > *=IF(SUMPRODUCT((nmc!$C3:$N3=TRUE))>0;IF(nmc!$A3<>"";"Has Text & Has > CheckMark";"");"")* > > But i'm almost there: > I used the formula you created. But then any price increase is still not > displayed: > > > *[image: ak.png]* > > > In the example below, there is a price increase from the month of > February. The price has risen from 25 to 40 (cell AP3) euros from February, > because cell AR3 is checked. However, on the tab "john" cell F4 is still > displayed 25 euros (see the image above). > I think there is still a very small error in the formula, but my formula > knowledge is not large enough to be able to solve this :( > So I could still use some help ;) > > *[image: ak1.png]* > Op vrijdag 8 april 2022 om 09:48:51 UTC+2 schreef parame...@gmail.com: > >> >> *"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."*Try >> below formula in *Jan<E4* (checks A3 has a text + C3:N3 has any >> checkmark ,Then displays *"Has Text & Has CheckMark* " else leave blank). >> >> *=IF(SUMPRODUCT((nmc!$C3:$N3=TRUE))>0;IF(nmc!$A3<>"";"Has Text & Has >> CheckMark";"");"")* >> >> >> *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".*Try below formula in *Jan<F4* (Checks whether AP3>B3 >> & C3:N3 has any checkmark & AQ3 is checked - IF all these three conditions >> are TRUE together then displays AP3 else put B3) >> >> >> *=IF((nmc!$AP3>nmc!B3)*(nmc!$AQ3=TRUE)*((SUMPRODUCT(nmc!$C3:$N3=TRUE)>0));nmc!$AP3;nmc!$B3)* >> Hope it helps. >> On Thursday, April 7, 2022 at 7:42:41 PM UTC+5:30 alexk...@gmail.com >> wrote: >> >>> 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 parame...@gmail.com: >>>> >>>>> 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 alexk...@gmail.com >>>>> 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 parame...@gmail.com >>>>>> : >>>>>> >>>>>>> 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 alexk...@gmail.com >>>>>>> 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 >>>>>>>>> parame...@gmail.com: >>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> >>>>>>>>>> What should be output for the given sample? >>>>>>>>>> >>>>>>>>>> On Sunday, April 3, 2022 at 3:05:46 PM UTC+5:30 >>>>>>>>>> alexk...@gmail.com 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 google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/62a09c4f-abdb-4118-99c7-24c43749f70fn%40googlegroups.com.
