I have two work sheets, Certain Information that is entered into the first one also displays on the second sheet. My formula on the second sheet is as follows =('Master Summary'!C7). This displays the data fromt he first sheet.
Which works fine, but when there is no data entered on the first sheet, the second sheet displays a pound sign.
Is there any way to have the cell blank on the second sheet if no data is entered into the first sheet. ..??
G
Oh and also, this are probably stupid questions, I also have percentage calculations on my sheets, the cells are formatted as percent, But when there is not value hey display #DIV/0!, is there a way of displaying this cell as 0% id there is no data entered ...???
Last edited by drgogo; 07-07-2008 at 05:32 AM.
Hi, modify C7 on the Master sheet. i.e.
=IF(yourformula=0,0,yourformula)
Similarly re your 2nd Q.
=IF(ISERROR(yourformula),0,yourformula)
HTH
re Second Question
IF(ISERROR,(ROUNDDOWN(SUM($Q$24:$Q$28)/$Q$23,2),0,ROUNDDOWN(SUM($Q$24:$Q$28)/$Q$23,2)
Above is the formula using your idea, I've probably got commors and brackets int he wrong place or missing, but it didn't work.
The idea for the first question also didn't work, still displaying characters in the field. Formula below
=IF('Master Summary'!$C7=0,0,'Master Summary'!$C7)
Again, probably got commors or brackets int he wrong place lol
After a bit of playing around, got the answer to question one to work, just had to change one of the "0" to just "", as its a text field and not a numeric field. Still having problems with question 2 thou...
Update, thanks for your help, have sorted it now, all working like a dream at the moment lol
Last edited by drgogo; 07-07-2008 at 06:01 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks