Forum Discussion
Solved
Adding IF cells.
Hi all. I have a column using an IF formula to create a value. I then want to add those values; however, as they are not numbers (even though the cell is formatted as such), I cannot get them to au...
Just use numbers in source formulae, not texts. Like
=IF(D2=M$2,0, IF(D2=M$3, 5,IF(D2=M$4,10,IF(D2=M$5,15))))
Just use numbers in source formulae, not texts. Like
=IF(D2=M$2,0, IF(D2=M$3, 5,IF(D2=M$4,10,IF(D2=M$5,15))))
Perfect. Thank you. I put the quotation marks in to produce the result. Now they're removed, it works a treat.
Many thanks
Dave