Forum Discussion
Solved
Setting cell values to 0 based on another cell
Hello hello, I am creating a sheet to keep track of costs that are distributed across participants in a conference. How much each participant will pay is based on how many modules they register ...
adriansaetrang Extend the current formulas as follows:
=IF(status="Deregistered",0,formula)
where status is the cell reference where it says Registered or Deregistered on the same row.
adriansaetrang Extend the current formulas as follows:
=IF(status="Deregistered",0,formula)
where status is the cell reference where it says Registered or Deregistered on the same row.
That's exactly what I was looking for. Thank you!