Hi,
Could you please help with this formula:
A1 4900
A2 4900
=(A1*2+A2)/450+IF(A1>4800,6,IF(A1>2400,4,IF(A1>0,2,0+(IF(A2>4800,6,IF(A2>2400,4,IF(A2>0,2,0)))))))
Should be 44.6667
But I get 38.6667.
Cant get the last bit of the formula to work.
Could you please help with this formula:
A1 4900
A2 4900
=(A1*2+A2)/450+IF(A1>4800,6,IF(A1>2400,4,IF(A1>0,2,0+(IF(A2>4800,6,IF(A2>2400,4,IF(A2>0,2,0)))))))
Should be 44.6667
But I get 38.6667.
Cant get the last bit of the formula to work.