Using Functions

  • Thread starter Thread starter Muskrat24
  • Start date Start date
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?
 
=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
 
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?
 
Back
Top