If then statement with a condition?

[richp803]

I have a statement =IF(B11:B200="Total",$J$1,"") which works fine. I now need it to say that if $J$1 is a blank cell, then return $K$1 as the answer. (The answer to my If statement will either be in J1 if there is data in that cell or in K1 if there is nothing in J.)

Any help is appreciated, thanks.

 

[Jonmo1]

Try

=IF(B11="Total",IF($J$1="",$K$1,$J$1),"")

 

[richp803]

Fantastic, looks like that will work, thanks!