excel easy but troublesome if statement

[rvd48]

hi,

im trying to solve my if statement:

=IF(D88>1,"-","")

i want it to do this: if there is any text in cell D88, then show a dash (-) otherwise display nothing.

i need to get rid of the >1 , but i dont know what to replace it with that signifies as text.

any help please?

 

[mhartman]

Hello:

Check out the IsText(Value) and IsNonText(Value) function in Excel.

In your case, something like If(Istext(D88),"-","")

Not tested though

Regards
Mark

 

[Brianwarnock]

=If(Istext(d88),"-","")

Brian

Mark beat me to it, it works.

 

[rvd48]

thanks guys

it works a treat, i saw the Istext in excel help files but it only outputted a 'True' or 'false' option.

next question is, sometimes cell D88 can have a '0' value in it, how can i get the Istext formula to dissmiss it into thinking the cell is empty?

regards
rvd48

 

[Brianwarnock]

Are we getting the full story here? 0 is numeric and the Istext will thus cause "" to be selected.

Brian

 

[shades]

Use an OR statement inside the IF.
________
Mercedes-Benz Econic

 

[rvd48]

tar chaps, got it to work with a OR addtion

=IF(OR(ISTEXT(D88),D88=0),"-","")

took some time trying to find out where to stick the OR text but finally got there.