I have an If/Then statement that has been working for a few months now
=IF(B11:B400="Total",IF($K$1="",$J$1,$K$1),"")
Where if the word "Total" is in Column B the data from either J or K would be entered into the cell where the formula resides. It turns out now, that column M may contain this data as well.
In short I need to modify the above so that it looks in J1, K1 and M1 for the answer to the query.
any help is appreciated.
thanks
=IF(B11:B400="Total",IF($K$1="",$J$1,$K$1),"")
Where if the word "Total" is in Column B the data from either J or K would be entered into the cell where the formula resides. It turns out now, that column M may contain this data as well.
In short I need to modify the above so that it looks in J1, K1 and M1 for the answer to the query.
any help is appreciated.
thanks
