Show Blanks

[Silvermini63]

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.

 

[Anne Troy]

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]

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]

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

Learn to use isblank, iserror, and isna