Forum Discussion
Digital Sum Formula
Please advise a formula for - I have two columns to record players scores, A,B, Column B is to show 21 when 0 to 21 is entered in column A, but column B must show nothing until an number is entered...
Hi David,
To your formula
=IF(B3<21,21)
add one more IF to check if the cell in column to compare is empty
=IF(ISBLANK(B3),"",IF(B3<21,21))