Forum Discussion
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 for and how many nights they stay in a hotel.
The different prices (price, conference, agency, extra) are retrieved from a separate sheet, while the Status column is a dropdown with "registered/deregistered".
So, when setting the status to "Deregistered" is it possible to automatically make all cells 0/blank like the example in the third row under Module 2?
It is important that the formulas in each cell are protected so that they will still show prices from the other sheet when status is "Registered"
Thank you!
Best,
Adrian
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.
2 Replies
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!
