If Statement...?

[grizzfan23]

Trying to see what the formula would be if I had two columns with values and needed to input them into the third column.

In the third column I want the value of the first column, unless there is a value in the second column.

What formula should I use?

Thanks,
MK

 

[sandy666]

maybe: =IF(ISBLANK(B2),A2,"")

 

[steve the fish]

Maybe try this?

=IF(B1<>"",B1,A1)

 

[grizzfan23]

Steve the fish, that was it. Thank you for your help!

Maybe try this?

=IF(B1<>"",B1,A1)