Im very new to spread sheet programs, and i have learnt some formulas however im very confused by this problem.
some notes to help people understand “J3” houses a drop down menu with the options Not Paid, Paid , Not Done, D references my prices column.
in one cell i have this formula =IF(J3=“Not Paid”,(SUM(D3-D3*2)))
and in another cell i have this formula =IF(J3=“Paid”,(INDEX(D3))) (D references my prices column)
these formulas work fine in separate cells but i would really prefer these operations in 1 cell.
i have tried =IF(J3=“Paid”,(INDEX(D3)=IF(J3=“Not Paid”,(SUM(D3-D3*2)))))
but that makes the cell always read “0” no matter what the drop menu selects.
How do i fix this? Im assuming my formula is very wrong but i dont know why, can someone please help me?