Forum Discussion
Solved
Background Formula?
I have two tabs on my spreadsheet - one for my data and one for my values. In my data sheet, I have a chart like this: Section = 25% A B C D E F G 1 Inadequate Below Std Standa...
No, that is not possible.
I'd use column H as "Corrected Rating".
If the calculated rating in column G is OK, leave column H blank.
If you want a "manual" rating, enter it in column H.
To calculate the total score, use the value in column H if available, otherwise the value in column G.
No, that is not possible.
I'd use column H as "Corrected Rating".
If the calculated rating in column G is OK, leave column H blank.
If you want a "manual" rating, enter it in column H.
To calculate the total score, use the value in column H if available, otherwise the value in column G.
- Thank you, Hans. I didn't think so, but thank you for the work-around. That should work.
