SOLVED

IFS vs SumProduct

Copper Contributor

I've been searching for formula help and nothing I've found seems to be the answer. Any help would be greatly appreciated! Here's what I'm trying to do: 

I have a column (C) where the value will either be 10 or 20. If the value is 10, I'd like the value in column F to carryover to column G. If the value is 20, I'd like the value in column F to be multiplied by 2 and that value dropped in column G.  

2 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@K_Shepherd Let's say you want to enter such a formula in G1, use a formula like  =C1/10*F1 and copy it down.

It worked! Thanks!

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@K_Shepherd Let's say you want to enter such a formula in G1, use a formula like  =C1/10*F1 and copy it down.

View solution in original post