Good Morning,
I have the spread sheet done, but I was wondering if it was possible to make the cells that have formulas in them appear empty until conditions are added. Right now, they have 0's and #DIV/0!. I have some of the fields filled in on the example attached, and any help would be appreciated.
Thanks,
Kat
Try this:
Please Login or Register to view this content.
Click (*) if you received helpful response.
Regards,
David
For the #DIV/0 error you can use something like this =IFERROR((F2-H2)/B2,"")
For the 0's, you can set your setting to not show zero's. If you got to Excel Options - Advanced - And under Display options for this worksheet, uncheck "show a zero in cells that have zero value"
or you can use this formula =IF(PRODUCT(B2:C2)=0,"",PRODUCT(B2:C2))
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
That worked out great!
Thanks for the help
Kat
You're welcome.
And if your problem really solved, please mark this thread as SOLVED
To mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks