# Show Blanks

#### Silvermini63

##### Active Member
Ok I am trying to figure out how to show a blank field on these formulas when there is nothing to report.

This one is a straight cell reference but due to a value in the ‘contract sheet if no code is entered it will bring up 0

='Contract Sheet'!B14

The next will show #VALUE

=IF(G14=0,D14/(100%-\$F\$2),(D14/(100%-G14)))

Last in the same will bring u #VALUE

=(F14-D14)/F14

If there is anyway of this shown a blank filed it will help me greatly and sorry if these are simple but sometimes they are the ones that trick me.

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Not sure what you really want:

=if(isblank('Contract Sheet'!B14),"",'Contract Sheet'!B14)

=IF(isblank(G14),"",if(G14=0,D14/(100%-\$F\$2),D14/(100%-G14))))

=if(isblank(f14),"",(F14-D14)/F14)

The first one is great thanks for that but the other two don’t work as G14 is the place to look first other wise take f2 as a base. This formula calculates Mark Up% so basically all I am trying to do is I there in nothing in g14 and d14 show blank.

thanks for you help

=if(and(isblankd(g14),isblank(d14)),"","yourformulahere")

Learn to use isblank, iserror, and isna

Replies
4
Views
252
Replies
7
Views
208
Replies
10
Views
579
Replies
6
Views
995
Replies
2
Views
173

1,219,798
Messages
6,150,318
Members
450,951
Latest member
kh198

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