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