I'm making a spreadsheet where it tallies the # of votes for types of video games played.
The categories are:
1st Person Shooter
Flight Sim
RTS
Turn Based Strategy
Now if I log in a vote for more than 2 types of games - say FPS and RTS, then the ticket has to be voidd.
I want it so that it displays VOID in a cell, and subtracts the appropriate votes from the total tally.
I'm using this for a survey - I get a bunch of filled out surveys and I record the data into Excel.
I'll be doing about 1000+ of these so I wanted Excel to help me out by just subtracting the voided votes automatically instead of having me go back and do it manually (about 10% is expeted to be voided)
I tried the if( function but it doesn't allow the modification of other cells.
need help! thanks!!!
The categories are:
1st Person Shooter
Flight Sim
RTS
Turn Based Strategy
Now if I log in a vote for more than 2 types of games - say FPS and RTS, then the ticket has to be voidd.
I want it so that it displays VOID in a cell, and subtracts the appropriate votes from the total tally.
I'm using this for a survey - I get a bunch of filled out surveys and I record the data into Excel.
I'll be doing about 1000+ of these so I wanted Excel to help me out by just subtracting the voided votes automatically instead of having me go back and do it manually (about 10% is expeted to be voided)
I tried the if( function but it doesn't allow the modification of other cells.
need help! thanks!!!
Facebook
Twitter