LinkBack URL
About LinkBacks
hi guys,
how to remove number "0" in the blank rows of horizontal scrollbar?please see sheet 'awal'.thanks
hi guys,
how to remove number "0" in the blank rows of horizontal scrollbar?please see sheet 'awal'.thanks
=If(your_formula="","",your_formula)
Life's a spreadsheet, Excel!
Say thanks, Click *
hi pejoi, how about adding an IF?
=IF(OFFSET(Sheet4!B3,kiraan!$C$3,0,1,1)="","",OFFSET(Sheet4!B3,kiraan!$C$3,0,1,1))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
the problem is remains unsolved.when i put an IF formula function given,the blank rows shows text as in sheet4.how to make the number '0' rows appear absolutely blank?
Click the Microsoft Office Button, click Excel Options, and then click the Advanced category.
Under Display options for this worksheet, select a worksheet, and then do one of the following:
To display zero (0) values in cells, select the Show a zero in cells that have zero value check box.
To display zero values as blank cells, clear the Show a zero in cells that have zero value check box.
thanks julieRV. i owed you!!
thanks everyone!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks