Hi there,

I'm looking to create an IF/OR statement. Basically, im looking to have a formula where if the cell in "C" says Bill or John, multiply the cell in "F" by 2. So far I only have the 1 if statement.

=PRODUCT(IFS($C:$C="bill",$F:$F*2))

Also, how would I do this if I wanted to multiply by different numbers. Eg. Bill to muliply by 2 and John to multiply 4

Also, how would I add a 3rd name? Any help would be great!