[Technology] Excel help needed!

F

Fungus

Well-known member

NSC Patron

May 21, 2004

7,045

Truro

• Sep 23, 2021

• #1

I run a football group, and I'm trying to simplify recording of the weekly subs, using a spreadsheet.

Starting with a Balance (F2), I want to add any weekly payments (E3, and below) and subtract £2 subs if they play (D3 = "Y", and below).

I thought the (fairly simple) formula shown would calculate a running balance, but something's wrong! Any ideas?

 

CheeseRolls

Well-known member

NSC Patron

Jan 27, 2009

5,939

Shoreham Beach

• Sep 23, 2021

• #2

Oxy McFloppie-Tish said:

I run a football group, and I'm trying to simplify recording of the weekly subs, using a spreadsheet.

Starting with a Balance (F2), I want to add any weekly payments (E3, and below) and subtract £2 subs if they play (D3 = "Y", and below).

I thought the (fairly simple) formula shown would calculate a running balance, but something's wrong! Any ideas?

View attachment 140652

Click to expand...

-IF not -iif ?

 

Albion_Dave

Well-known member

Jul 4, 2011

2,108

Eastbourne

• Sep 23, 2021

• #3

To many i's in your iif

 

surrey jim

Not in Surrey

Aug 2, 2005

18,092

Bevendean

• Sep 23, 2021

• #4

Surley its just a mis spelling of 'IF'

 

W

Wardy's twin

Well-known member

Oct 21, 2014

8,433

• Sep 23, 2021

• #5

Albion_Dave said:

To many i's in your iif

Click to expand...

the irony of needing extra eyes to see the extra i

 

schmunk

"Members"

Jan 19, 2018

9,479

Mid mid mid Sussex

• Sep 23, 2021

• #6

 

F

Fungus

Well-known member

NSC Patron

May 21, 2004

7,045

Truro

• Sep 23, 2021

• Thread starter
• #7

Ah, I thought I needed the "Immediate IF" function rather than the humble "IF"!

Brilliant, thanks all. It was so much simple when I made them bring £2 every week, rather than bank transfers or tenners!

 

Simster

"the man's an arse"

Jul 7, 2003

54,165

Surrey

• Sep 23, 2021

• #8

Oxy McFloppie-Tish said:

Ah, I thought I needed the "Immediate IF" function rather than the humble "IF"!

Brilliant, thanks all. It was so much simple when I made them bring £2 every week, rather than bank transfers or tenners!

Click to expand...

IIF is what you'd use in Excel VBA, but use IF in a formula.