Add formula to existing formula

[jpatierno]

Totally new to this so I have this formula in the formula bar for a cell
=+ALLDATA!BN6. I want to put an IF statement saying that if T6/220 >= 7.5 then BN6 else BM6. Also what is the exclamation point for

 

[Joe4]

Welcome to the Board!

Try:

=IF(ALLDATA!T6/220>=7.5,[COLOR=#333333]ALLDATA!BN6,[/COLOR][COLOR=#333333]ALLDATA!BM6)[/COLOR]

You alsoways use the exclamation point between the sheet name reference and the range reference.

 

[jpatierno]

beautiful