if-then functions

B

Becky

I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want
"Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How?
Thanx
 
D

Dave Peterson

Type this formula in B2 of Sheet2:

=if(countif(Sheet1!b7,"*"&"certain"&"*")=0,"",sheet1!b8)

=countif() will treat the * as a wild card. So "certain" could be anywhere in
that B7 Cell.
 
B

Brad

=if('sheet1 B7'="Desired Word",'Sheet 1 B8","")
This has to be done in "Sheet2 B2"

Please note that there is normally a "!" between the sheet and the cell
location.

If you start by typing in the "If" statement and use the mouse to point to
the cells desired XL will put in the correct notation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if-then statements or functions 3
Excel Help Needed 1
Excel Help to copy information from one row at a time to another sheet 1
Need Help with an Excel Formula! 9
if between statement 3
IF FUNCTION 7
Excel, assign cells in multiple worksheets from one sheet 1
IF formula returns FALSE 1

Top