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:
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,
>
>
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 w
; 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
uesday, 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:
>>>>
>>
en 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
a
>>>> 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.
>>>>
>
il.com
> wrote:
>
>> One last thing:
>> In the example below in January I did not check dog food (cell 4)
>> [image: at1.png]
>>
>>
>> Now, on the "January" tab, cells E5 and F5 should remain empty. See the
>> example below.
>>
..@gmail.com
> wrote:
>
>> One last thing:
>> In the example below in January I did not check dog food (cell 4)
>> [image: at1.png]
>>
>>
>> Now, on the "January" tab, cells E5 and F5 should remain empty. See the
>> example below.
>>