How to make a function work only if other cells in the row have values..

[trickdigger]

I'm working with an if statement that enters a certain value if th
average is a certain value, but I want to make it so that I can hav
the formula in the cell, but not have it return a value until the othe
fields are in the row have been filled. So I would use some sort of i
statement

 

[Paul B]

trickdigger, one way is to use isblank something like this,
=IF(ISBLANK(A1),"",B1+C1)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"trickdigger" <[email protected]>
wrote in message
news:[email protected]...

 

[Kayote]

May I add a question to that please.

How would one go about setting up the formula if there is a range an
we donot want to run a function if there is no data in any one of th
cells in the range?

cheer

 

[Paul B]

Kayote,
I think ISBLANK works only for a single cell, but maybe some of the guru's
here know of a way to do it, but you could use something like this

=IF(OR(ISBLANK(A1),ISBLANK(A2),ISBLANK(A3)),"",B1+C1)


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Ragdyer]

One way:

=IF(COUNTIF(A11,">0")=4,AVERAGE(A11),"Need More Data")

 

[Max]

=IF(OR(ISBLANK(A1),ISBLANK(A2),ISBLANK(A3)),"",B1+C1)

This expression returns the same results as the above,
but needs to be array-entered (i.e. press CTRL+SHIFT+ENTER):
=IF(OR(ISBLANK(A1:A4)),"",B1+C1)

---

 

[Max]

Belated slight typo correction:

=IF(OR(ISBLANK(A1:A4)),"",B1+C1)

Line should have read as:

=IF(OR(ISBLANK(A1:A3)),"",B1+C1)

to be consistent with Paul B's suggestion <g>

---