Hakuna Matata
I have a cell formated like [MM]:SS,00. I want when the timer reach below zero that this cell change to ready and do not show anymore the timer. This my function for this Cell: If(B3="Start";3000*$V$2;IF(F3<=0;B3="Ready")) The V2 cell hast the value 00:00,01 to get easy to set timer to the value i want. I got only a error 522 When the timer reaches zero or below zero. Is there any solution to show text on a cell this is time formated?
Have a nice day
neitro
Want a time cell turned to ready when it is below Zero
Want a time cell turned to ready when it is below Zero
OpenOffice 4.1.9 on Windows 10
Re: Want a time cell turned to ready when it is below Zero
Please upload your sample file here.
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.
Re: Want a time cell turned to ready when it is below Zero
Welcome to the Forums
You can't use an IF statement to assign a value to a specific cell, which is what your formula appears to attempt to do.
I have to concur with Zizi64, that a sample of your spreadsheet is needed before we can realistically be of help.
There are just too many things we don't know, and a sample of your spreadsheet would resolve most, if not all, of those.
You can't use an IF statement to assign a value to a specific cell, which is what your formula appears to attempt to do.
I have to concur with Zizi64, that a sample of your spreadsheet is needed before we can realistically be of help.
There are just too many things we don't know, and a sample of your spreadsheet would resolve most, if not all, of those.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Want a time cell turned to ready when it is below Zero
Use a conditional format for value <= 0
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice