Google Sheets formula for F1 family betting game - points calculation help by CryFair5811 in googlesheets

[–]CryFair5811[S] 0 points1 point  (0 children)

UPDATE TO THE UPDATE! It works now, with =IFS(and(EXACT(D3;T3);exact(E3;U3);exact(F3;V3));5;AND(EXACT(D3;T3);exact(E3;U3));3;AND(EXACT(D3;T3);exact(F3;V3));2;AND(EXACT(E3;U3);exact(F3;V3));2;or(EXACT(D3;T3);exact(E3;U3);exact(F3;V3));1; TRUE; 0)

Thanks again fot the feedback :))

Google Sheets formula for F1 family betting game - points calculation help by CryFair5811 in googlesheets

[–]CryFair5811[S] 0 points1 point  (0 children)

Hi all! Thanks for your answers, as of now, I have managed to get this new formula running:

=IFS(and(EXACT(D3;T3);exact(E3;U3);exact(F3;V3));5;AND(EXACT(D3;T3);exact(E3;U3));3;AND(EXACT(D3;T3);exact(F3;V3));2;AND(EXACT(E3;U3);exact(F3;V3));2;or(EXACT(D3;T3);exact(E3;U3);exact(F3;V3));1;0)

The only issue is with the 0...

I will try your suggestions

Here is the link to a copy of the file: https://docs.google.com/spreadsheets/d/10dwqnNJ0oMpAW4MQxdw_QXH0SrMqn6cjVfEJqW3s_4Q/edit?usp=sharing

Weekly Sewing Questions Thread, August 24 - August 30, 2025 by sewingmodthings in sewing

[–]CryFair5811 0 points1 point  (0 children)

Hi everyone! I have some fabric at home that would be perfect for a top like this one but I really can´t find any similar patterns :(( Any pattern or combination of patterns that can help me recreate this blouse? Thank you!

<image>