User Safety: safe
rows.com
When Nested IFs Fail: Troubleshooting Number Format Mismatches
Struggling with nested IF statements that match criteria but return unexpected results?
1 min readMicrosoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I have this formula and there are 4 out of 52 rows that match these numbers but the formulas are not returning the *0.8 formula results but acting as if they don't match the numbers called out and returning the G column value.
The A column is formatted as number, the result column is also formatted as number. There are no extra spaces. What am I missing?