Show Blanks

Silvermini63

Active Member
Joined
Sep 25, 2006
Messages
293
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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Anne Troy

MrExcel MVP
Joined
Feb 18, 2002
Messages
2,608
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)
 

Silvermini63

Active Member
Joined
Sep 25, 2006
Messages
293
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
 

Anne Troy

MrExcel MVP
Joined
Feb 18, 2002
Messages
2,608
=if(and(isblankd(g14),isblank(d14)),"","yourformulahere")

Learn to use isblank, iserror, and isna

:)
 

Forum statistics

Threads
1,171,826
Messages
5,877,767
Members
433,285
Latest member
iAbdullah

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top