Forum Discussion

TeresaSmags's avatar
TeresaSmags
Copper Contributor
Sep 21, 2022

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...
excel
Formulas and Functions
office 365
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Sep 21, 2022

TeresaSmags 

=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?

 

TeresaSmags's avatar
TeresaSmags
Copper Contributor
Sep 21, 2022
Yes, thank you!
  • TeresaSmags's avatar
    TeresaSmags
    Copper Contributor
    Sep 21, 2022
    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.
    • OliverScheurich's avatar
      OliverScheurich
      Gold Contributor
      Sep 21, 2022

      TeresaSmags 

      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.

      • TeresaSmags's avatar
        TeresaSmags
        Copper Contributor
        Sep 21, 2022

        OliverScheurich 

         

        Yes, correct, but it opens a second screen entitled Insert/edit images and has fields for me to fill in (not the usual insert capability like yours has!?)...Source, Image description, Dimensions, and then a checkmark box for Constrain proportions. Odd. And I've also received another message stating I "do not have permissions to upload images."

Resources