It is sometimes difficult for me to communicate through written text,
thanks to my poor language skills ;)
uh... I have to think carefully about how exactly to describe my wish for
the formula.
I'm thinking... wait for it :)
Op zondag 10 april 2022 om 08:28:24 UTC+2 schreef
You're right, my mistake. I hadn't read your answer correctly :(
Sorry about that. Anyway, I'm still very happy with the formula you
created.
Now that I have this perfect starting point, I can move on with my cash
book.
Op zondag 10 april 2022 om 08:28:24 UTC+2 schreef parame...@gmail.com:
Because earlier you said:
*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
Wow!
This is magic!
This is exactly what I was looking for.
I would like to thank you very much for sharing your knowledge and your
help.
Op vrijdag 8 april 2022 om 16:04:40 UTC+2 schreef parame...@gmail.com:
> See if this works for F4,
>
>
>
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
*"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
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
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
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
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,
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
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
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,
>
>
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,
14 matches
Mail list logo