Forum Discussion
Conditional Formula Help
Hi, I feel I’m stuck with quite a simple conditional formula (I think), but I just can’t figure it out. I have an expenses spreadsheet whereby if an employee enters ‘Y’ into the column, I nee...
=IF(G20="Y",SUM(H7:J20),"")
Thank you!! I hadn’t put the “” at the end to return the false result. I understand now why it wasn’t working 😊