•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
#AI formula generation techniques
#formula generator
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions