Forum Discussion
Nested IF formula help needed
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.
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."
Maybe we have different insert capability. Can you enter your data like in your first post along with the expected results?
If you insert the data like below it's easier to copy and paste the data into a worksheet. From a screenshot i'd have to manually type the data.
ID Employee Hire Date Code Date Type Earned Hrs Used Hrs Balance Hrs Earned $ Used $ Balance $ Gained/(Lost) Rate/Hr expected result 139 Smith, John 08/25/1998 PTOS 09/15/2022 E 3,85 56 485,88 7067,31 $ 126.202 126,2025974 139 Smith, John 08/25/1998 PTOS 09.08.2022 E 3,85 52,15 485,88 6581,43 $ 126.202 126,2025974 139 Smith, John 08/25/1998 PTOS 09.08.2022 C 48,3 6095,56 #DIV/0! 126,2020704 139 Smith, John 08/25/1998 PTOS 09.08.2022 U -8 48,3 -1009,6 6095,56 #DIV/0! 126,2025
