Try putting this formula in G12...

=IF(H12="Yes",B11,"")

--
Rick (MVP - Excel)


"Muskrat24" wrote in message
...
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?

"MurrayBarn" wrote:

Try:

=IF(A1="Yes",B1,"")



"Muskrat24" wrote:

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?