Forum Discussion
Nested IF formula help needed
Sorry, but for some reason I'm not allowed to upload a screenshot to easily decipher this problem of mine... The formula is not working in cell O4 (or O5). I realize it's probably due to the cond...
=IF(AND(G2<>0,J2<>""),J2/G2,IF(AND(H2<>0,K2<>""),K2/H2,IF(AND(I2<>0,L2<>""),L2/I2,"")))Does this formula return your expected result?
- Yes, thank you!
- Ok, after further review, it's not correct for some rows. How do I copy/paste a screenshot of my Excel spreadsheet? The system won't allow me and that's the easiest way to present and make sense of it.
After "Reply" -> "Open full text editor" you can select "Insert Photos" to choose the PDF.
Alternatively you can enter additional data and your expected results in the attached xlsx. file. Then you can save the file on your computer and in order to attach the xlsx. file you can select "Reply" -> "Open full text editor" and then select "browse" to select the file.
