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

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Anne Troy

MrExcel MVP
Joined
Feb 18, 2002
Messages
2,603
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,603
=if(and(isblankd(g14),isblank(d14)),"","yourformulahere")

Learn to use isblank, iserror, and isna

:)
 

Forum statistics

Threads
1,136,260
Messages
5,674,697
Members
419,520
Latest member
Jennifer4Dillon

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