NWPhotoExplorer
New Member
- Joined
- Jan 19, 2021
- Messages
- 34
- Office Version
- 365
- Platform
- Windows
- MacOS
I have a calculation that is adding up the values of some fields. I am trying to get it to highlight when the number it adds up to is a whole number, like 1, 2, 3, etc.
My calculation is =SUBTOTAL(9,T_JOBS[Hours (decimal)])
I tried using INT and MOD and some IF statements, but I am not coming up with anything that works. This has to be so simple, yet I've been struggling with it all day. Hopefully, someone out there knows how to do this!
Thanks in advance!
My calculation is =SUBTOTAL(9,T_JOBS[Hours (decimal)])
I tried using INT and MOD and some IF statements, but I am not coming up with anything that works. This has to be so simple, yet I've been struggling with it all day. Hopefully, someone out there knows how to do this!
Thanks in advance!