themaceisback
New Member
- Joined
- Jul 26, 2010
- Messages
- 1
I know this may be a relativly easy question but i cannot seem to find the answer anywhere. I want to, in a cell, run an if statement that will check multiple cells and run through its logic and return a function involving all of the values returned.
If what i said doesnt realy maker sense i want to check a certain column for a value (on) and if it is there i want to take a value from the same row but different column and put it into the function in the if true part of the if statement (which would calculate the average of the values entered)
If what i said doesnt realy maker sense i want to check a certain column for a value (on) and if it is there i want to take a value from the same row but different column and put it into the function in the if true part of the if statement (which would calculate the average of the values entered)