Basic formula help please...

[cmerrick]

Hi Guys,

I need a formula that performs the below. It should be easy but I can't nail it.

IF E8 = BLANK (No value) then "custom text", otherwise (if not blank), is the value >6 if true "custom text" otherwise " " (no value).

I was thinking something like...

=IF(ISBLANK(E8),"CUSTOM TEXT",ELSEIF(E8>6,"CUSTOM TEXT"),"")

But I know it's not quite right


Thanks in advance.

 

[AlanY]

try

=IF(ISBLANK(E8),"CUSTOM TEXT",IF(E8>6,"CUSTOM TEXT",""))

 

[cmerrick]

try

=IF(ISBLANK(E8),"CUSTOM TEXT",IF(E8>6,"CUSTOM TEXT",""))

Nice one, can't believe it was that easy

 

[AlKey]

Or get rid of ISBLANK function:

[B]=IF(E8="","CUSTOM TEXT",IF(E8>6,"CUSTOM TEXT",""))[/B]