You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
Your if function has the sum of 2000. you borrowed 20000.
change
=IF(SUM($C$6:D6)>2000,"Paid","")
to
=IF(SUM($C$6:D6)>$A$1,"Paid","")
and then it will look at the value in cell a1.