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

T

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
 
P

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]...
 
K

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
 
P

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
 
Top