Forum Discussion
=IF Formula Woes
Hello All! I'm working on a spreadsheet with a cell (C2) containing a drop-down menu. I'm trying to create a formula in another cell (D2) dependent on the selected item in the drop-down menu. I w...
I could see you really do not need a new formula maybe. Do some edits as below:
your formula =IF(C1="14 Day",SUM(B2*14))*C2,IF(C1="21 Day",SUM(B2*21))*C2, has absolute reference issues, there is also some issue with parenthesis. Compare with mine here,=IF($C$1="14 Day",SUM(B2*14)*C2,IF(C1="21 Day",SUM(B2*21)*C2)) and it will work perfectly i think. Maybe it is important for you, if not, why should you use 'Merge and Center', i am just been curios here😄.