Using Functions

M

Muskrat24

I am trying to make a function so that if the cell is "yes" that it will be
equal to another cell and if it is "no" than it is left blank. How do I do
this?
 
B

Bernard Liengme

=IF(A1="Yes",B1,"")
That is a pair of double quotes with nothing between them

The formula looks at A1 and if it has value Yes than the cell with the
formula gets B1's value, otherwise it displays nothing.
Of course, this formula can go in any cell other than A1 or B1
best wishes
 
M

Muskrat24

I tried it and it wouldnt work. the way I want it set up is if H12 is yes, I
want G12 equal to B11, is that possible to do?
 

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

Newbie Help - IF Yes No Function 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Excel - Wich Function should I use? 1
Excel Logical function 5
Conditional Formatting to Another Cell 0
Excel does not accept text format! 0
Using IF, AND and OR functions together 2
Matching literal text "???" in Word 2010 field code IF statement 2

Top