1-60 16.15
61-75 19.55
76-100 21.25
101-125 25.20
126-150 28.35
151-175 31.50
trying to turn that into a single IF function in a single cell, so i can just type in a number from the first column and get the number from that row.
[Solved] Multiple IF functions in one cell
[Solved] Multiple IF functions in one cell
- Attachments
-
- automated pay sheet.ods
- not finished but were i gave up to look for help
- (9.31 KiB) Downloaded 73 times
Last edited by Hagar Delest on Mon Jan 02, 2023 8:04 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
OpenOffice 4.1.5 on Windows 10
Re: multiple if functions in one cell
I think the formula in column H gives you what you want.
- Attachments
-
- automated pay sheet_fjcc.ods
- (9.86 KiB) Downloaded 81 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Multiple IF functions in one cell
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.