Hi guys,
I have a spreadsheet which when full will have about 20 landscape pages of fomuli ~1000rows.
I have forumli running through all the 1000 rows and they are all just printing 0's and errors (#value).
I have two IF statements which will remove them individually but I would like to combine the two if it is possible.
Formula 1
=IF(ISERROR($K71),"",($K71))
Formula 2
=IF('Calculation sheet'!K71=0,"",'Calculation sheet'!K71)
I presume there is just an & sign or something simple but I can't work it out.
Also, if this hides all the 0's and errors will it reduce the total pages to print to only where there is actuall data ? (Currently there are only 2 pages of data inputted and it wants to print 9 pages of 0's / #value errors.
Regards
Paul
I have a spreadsheet which when full will have about 20 landscape pages of fomuli ~1000rows.
I have forumli running through all the 1000 rows and they are all just printing 0's and errors (#value).
I have two IF statements which will remove them individually but I would like to combine the two if it is possible.
Formula 1
=IF(ISERROR($K71),"",($K71))
Formula 2
=IF('Calculation sheet'!K71=0,"",'Calculation sheet'!K71)
I presume there is just an & sign or something simple but I can't work it out.
Also, if this hides all the 0's and errors will it reduce the total pages to print to only where there is actuall data ? (Currently there are only 2 pages of data inputted and it wants to print 9 pages of 0's / #value errors.
Regards
Paul