•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Nest if statement matches but not returning correct data
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?
=IF(A28="10151334",C28*0.8, IF(A28="10643958",C28*0.8, IF(A28="10643959",C28*0.8, IF(A28="10149450", C28*0.8,G28))))
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com