I have a formula that enables a cell to enter a number into a different cell (if(b7=“YES”,“1.1”,"").
There is a row of these results which I then want to autosum.
If I understand correctly the " identifies the cell as text and ignores it when autosum is used.
I am struggling to understand how to resolve this.
All guidance apprciated.
Cheers
Rick
Is there any reason to quote the 1.1? This works for what you describe =IF(B7="Yes";1.1;"")
1 Like
It is to calculate a handicapping system for a rowing competition. This is accumulative of 3 factors, age, sex, and crew gender mix. The 1.1 is part of that. Getting this figure into a cell to multiply is the issue.
The above equation works. I just cannot, then autosum the 3 different results
Cheers
Rick
In your formula if(b7="YES","1.1","") using "1.1" displays the result as text; if you omit the surrounding quotation marks it will be displayed as a number which will allow SUM to give the expected result.