The Shadowman
New Member
- Joined
- May 5, 2021
- Messages
- 47
- Office Version
- 2019
- Platform
- Windows
=IF(U8<34,T8+1,IF(U8="dnp",T8,IF(U8=34,T8,IF(U8=35,T8,IF(U8=36,T8,IF(U8=37,T8,IF(U8=38,T8-1,IF(U8=39,T8-1,IF(U8=40,T8-1,IF(U8>40,T8-2,IF($CH8="shots back blocked",T8)))))))))))
The formula above is in Column "V" and should respond to information from columns "T" and "U" only. However, when the data in T and U is provided it changes columns R P & N in error. I can not work out for the life of me why this is happening. R P and N should not be affected.
Is there an error in the formula? If there is I can't find it.
Please help
Thanks
Robert
The formula above is in Column "V" and should respond to information from columns "T" and "U" only. However, when the data in T and U is provided it changes columns R P & N in error. I can not work out for the life of me why this is happening. R P and N should not be affected.
Is there an error in the formula? If there is I can't find it.
Please help
Thanks
Robert