#### cmerrick

##### Board Regular
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

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
try

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

Last edited:
try

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

Nice one, can't believe it was that easy

Or get rid of ISBLANK function:

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

Replies
4
Views
155
Replies
4
Views
342
Replies
9
Views
234
Replies
16
Views
364
Replies
2
Views
169

1,203,082
Messages
6,053,419
Members
444,662
Latest member
AaronPMH

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back