If Function with formula

Foz

Hi,

Please can anyone help.....

I need to use the IF Function for the following, any help appreciated.

IFCell= CFI then return unit total as 0, If cell = not cfi then SUM A1*A2

Many thanks

Brent Wilson

remember Smartsheet is not Excel..

So if you are talking in a single row.. this will evaluate for columns

=IF(CheckCell@row = "CFI", 0, ColumnA@row * ColumnB@row)

If you have static values loaded in the Primary Column in row 1 and 2

=IF(CheckCell@row = "CFI", 0, [Primary Column]1 * [Primary Column]2)