I am looking to put a slash into a specific cell depending upon the content of another cell. Could use some help! I have attached the spreadsheet. I am looking to put a slash in cell p5 conditional upon b5 being "UC".
Thanks,
Mick
[Solved] How to put slash in specific cell
-
- Posts: 4
- Joined: Mon Dec 23, 2019 10:15 pm
[Solved] How to put slash in specific cell
- Attachments
-
- CABINET CUTLIST V.6.1.ots
- (93.96 KiB) Downloaded 90 times
Last edited by MrProgrammer on Sat Oct 31, 2020 9:11 pm, edited 3 times in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
OPENOFFICE 4.1.7 ON WINDOWS 10
Re: how to put slash in specific cell
I'm not sure if I understand your problem but...
Your cell P5 is currently empty (no code), so why don't you just use:
=IF(B5=”UC”;”/”;””)
In cell P5?
Your cell P5 is currently empty (no code), so why don't you just use:
=IF(B5=”UC”;”/”;””)
In cell P5?
Mikael S. Hansen
Apache OpenOffice 4.1.8
Windows 10
Apache OpenOffice 4.1.8
Windows 10
Re: how to put slash in specific cell
Your sample file contains some MS Excel VBA macro code.
Do you want to put the slash by a macro? What event do you want to assign your macro to?
(You need rewrite your VBA macros based on the API functions and procedures of the AOO/LO.)
Do you want to put the slash by a macro? What event do you want to assign your macro to?
(You need rewrite your VBA macros based on the API functions and procedures of the AOO/LO.)
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 4
- Joined: Mon Dec 23, 2019 10:15 pm