I have spent the morning trying to figure out how to do this. I admit that my thinking is stuck on using IF. I have also explored conditions. Something simpler might be more appropriate. Searches have taught me a lot but I haven't had the results by using what I have learned. Certainly this is done all the time and the solution will embarrass me.
I want to type a word in a column that describes a work type. Depending on which of the 3 words that I type, I would like defined cost of the service to appear in another column and the defined cost of materials in another column.
eg. Build = 15, 10
Replace = 10, 5
Inspect = 5, 1
[Solved] Amount to appear in a column when I type a word in
[Solved] Amount to appear in a column when I type a word in
Last edited by DubDar on Mon Mar 18, 2019 1:40 am, edited 1 time in total.
OpenOffice 4.1.6. Windows 10
- MrProgrammer
- Moderator
- Posts: 4895
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: I want an amount to appear in a column when I type a wor
Hi, and welcome to the forum.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
[Tutorial] Ten concepts that every Calc user should know
[Tutorial] VLOOKUP questions and answersDubDar wrote:I want to type a word in a column that describes a work type. Depending on which of the 3 words that I type, I would like defined cost of the service to appear in another column and the defined cost of materials in another column.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: Solved amount to appear in a column when I type a word i
That did it. Didn't see any mention of VLOOKUP in help or in searches.
Many Thanks!
Many Thanks!
OpenOffice 4.1.6. Windows 10