cell formating

  • Thread starter Thread starter NYBoy
  • Start date Start date
N

NYBoy

I like to format the cell so that #DIV/0 wouldn't apper in the cell i
parent data is not available yet.

e.g.

A1 = A2/A3
BI = B2/B3
C2 = C2/C3
and so on.......

data for A2,A3,B2,B3 are available but
data for C2,C3,D2,D3...... are NOT available yet.

I want to see blank cell if C2,C3,D2,D3.....are not filled yet.
Any help
 
=IF(OR(ISBLANK(A2),ISBLANK(A3)),"",A2/A3)

OR

=IF(ISERROR(A2/A3),"",A2/A3)

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
Anne you are the best!

how about something little more complicated

=SUM(O41,O45,O49,O53,O57,O61,O65,O69
 
So, you don't want a sum if ANY ONE of them is blank?
I'd love to see the layout of your workbook. Seems to me it's definitely not
*ideal*. Here's *ideal*:
http://www.theofficeexperts.com/excel.htm#FileLayoutForDatabases

=if(or(isblank(o41),isblank(O45),isblank.....),"",sum(O41,O45,O49....)

You can complete the rest of the formula. But that's a pretty heavy formula.
Email me your file if you want me to have a look at the layout.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
Back
Top