Forum Discussion
Excel formula help
Hello,
I'm sorry but are you aware that IF H2=0.5 ( or 0.2, ...) the two conditions are accepted ?
they intersect!
Ahmad, the formula you gave me ALMOST works, but for some reason A student who chooses option 2 comes out at a 90 instead of 100. See attached.
Another variant is
=SUM(D2:I2)-E2*(H2=0)
Sergei, I don't want to delete E2--there should always be points in columns D-E, plus points from either H or I (not both). Removing E2 from your formula leaves
=SUM(D2:I2)*(H2=0) results in a score of 0 for Test Student Option 1
=SUM(D3:I3)*(H3=0) results in a score of 100 for Test Student Option 2
Both should be 100.
I know this stuff is way beyond my basic skill set, but why would I want to subtract the value from E2?
Since based on your requirement if H2=0 you sum
prr924 wrote:
then C2 =SUM(D2,F2,G2,I2).
other words all from D2 to I2 but E2 and H2.
H2 is zero under this condition, thus you need to substruct only E2 from full sum.
