•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
Our take
Struggling with nested IF statements that match criteria but return unexpected results? Your formula correctly targets specific A-column values to apply an 0.8 multiplier to C-column data, yet 4 rows fail to update. Double-check that A-column cells match the quoted values exactly, including formatting and hidden characters. Ensure C-column values aren’t blank or non-numeric, which could disrupt calculations. If issues persist, review cell references for typos or unintended spaces.
User Safety: safe
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]
Read on the original site
Open the publisher's page for the full experience
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