LinkBack URL
About LinkBacks
What i am looking to do is have column D display the value in column B...if column C is not blank. Here is an example. Thanks for any help.
EXAMPLE.xls
What i am looking to do is have column D display the value in column B...if column C is not blank. Here is an example. Thanks for any help.
EXAMPLE.xls
Last edited by keith6292; 10-31-2009 at 11:03 AM.
=if(isnumber(c6),b6,"")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Try this
=IF(C6="","",B6)
both examples work perfect. but what if i wanted column D to say "complete" or "finished" when cell b6 and c6 are not blank.
Try..
=IF(OR(C6="",B6=""),"","Finished")
Or subsitute Finished for whatever word you want.
EDIT
The above is if either is blank.
If you want it if both are blank
=IF(AND(C6="",B6=""),"","Finished")
Last edited by jj72uk; 10-31-2009 at 10:14 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks