suertetres
New Member
- Joined
- Nov 8, 2023
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
This may be more of a math rule question and I'm absolutely stumped on how to write the formula. I'm trying Multiple a cell by 4 then subtract it from another cell. For example, A1 is 778 and A2 is 3122. I'm trying to multiply A1 by 4 and then subtract that from A2. 778x4-3122. My current formula is =A2-A1*4. The answer it gives me is 10, but it should be zero. Can someone help me correct my formula?