Hi,
I'm trying to get a spreadsheet to read a formula that will return a dash (-) as a zero (0) whilst any other number, including zero (0), is to be returned as a one (1).
My current formula reads a dash and zero both as zero's and so returns the wrong answer.
=IF(H16="-",1,0)
if true = 1
if false = 0
Any idea's how I can prevent this?
Cheers,
Dave
I'm trying to get a spreadsheet to read a formula that will return a dash (-) as a zero (0) whilst any other number, including zero (0), is to be returned as a one (1).
My current formula reads a dash and zero both as zero's and so returns the wrong answer.
=IF(H16="-",1,0)
if true = 1
if false = 0
Any idea's how I can prevent this?
Cheers,
Dave