Is there an 'IFONLY' formula

[MTarlinton]

Not totally sure, but is there an 'IFONLY' formula. Formula below (not mine, so don't really understand it anyway). However 'sheet1!d10' has text, some having a number as well. I basically want to to read that if its only text in the cell to read blank. If its only '0 text' to read blank. But if its reading '60 text' it reads only the number, which it is already doing.


=IF(ISBLANK(Sheet1!D10),"",SUMPRODUCT(MID(0&Sheet1!D10,LARGE(INDEX(ISNUMBER(--MID(Sheet1!D10,ROW(INDIRECT("1:"&LEN(Sheet1!D10))),1))*ROW(INDIRECT("1:"&LEN(Sheet1!D10))),0),ROW(INDIRECT("1:"&LEN(Sheet1!D10))))+1,1)*10^ROW(INDIRECT("1:"&LEN(Sheet1!D10)))/10))

Ive tried 'isnumber' 'search', but reads that if text or number is in cell, it reads blank.

[6StringJazzer]

There is no built-in function that is a simple way to do what you want. What you are asking is basically parsing the contents of a cell, which Excel can do but it isn't very good at it.

I tried your formula and I don't know how it works either but it seems to return what you want, except it returns a 0 instead of a blank. Try adding

&""

at the end of the formula.

The other way to do this is to write a VBA function to do exactly what you want, if you want to go that direction.