# formula only work if other cell has data

#### Kirstym1918

##### New Member
Hi all,
Could anyone help me with this formula below, I would likeit to only calculate and return “SPARE/VOR” if D78 is not blank but I have noidea where to nest it in the formula but not for want of trying would it be =NOT(ISBLANK)?

If someone would be so kind as to add it to the formula andexplain it to me, I would be very grateful

=IFERROR(IF(MATCH(D78,Monday!\$C\$6:\$C\$122,0),"ROUTE",),"SPAREor VOR?")
Thanks

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Try

=if(D78="","",IFERROR(IF(MATCH(D78,Monday!\$C\$6:\$C\$122,0),"ROUTE",),"SPAREor VOR?"))

The part in RED says IF D78 is blank, then return a blank, otherwise run your formula.

hth

And so simple, I really do over complicate things when it comes to working out formulas

Many thanks Gaz

You're welcome.

Replies
7
Views
297
Replies
8
Views
77
Replies
5
Views
225
Replies
2
Views
106
Replies
2
Views
172

1,203,224
Messages
6,054,237
Members
444,711
Latest member
Stupid Idiot

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