[Solved)] IF() Formula
[Solved)] IF() Formula
this formula will not calculate =if(G4>0;(G4*$C$1/100);"") trying to calculate tax rate at 6.75% ,,, changed computers this formula worked on old computer. tnx, mike
Last edited by Hagar Delest on Sat Apr 20, 2019 10:54 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
open office 4.1.6
Re: formula
/View /Value highlighting, to check if your values are numeric or text.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: formula
iam assuming they are numeric, turned blue and red, ????RoryOF wrote:/View /Value highlighting, to check if your values are numeric or text.
open office 4.1.6
Re: formula
Numbers will be blue, text black, and formulas in green.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: formula
iam sorry , i have a problem with colors,,, so my blue numbers are not formulas, and my green numbers are formulas,,and in this row/column the number is green but not calculating. when i highlight the cell it shows the formula in there. Is it possible to send you a copy of my spreadsheet? tnx, mikeRoryOF wrote:Numbers will be blue, text black, and formulas in green.
open office 4.1.6
Re: formula
I have open office 4.1.6 , My system is windows 7, when i signed up the only option was oo3.1
open office 4.1.6
Re: formula
Turn OFF Tools>Options>Calc>View>Display Formulas
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
Re: formula
In the Header of this forum - User Control Panel - Porfile (TAB) - Edit signature (SubTAB): Just edit the text of your signature.I have open office 4.1.6 , My system is windows 7, when i signed up the only option was oo3.1
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: formula
Hit the [Post Reply] button, not [Quick Reply].bulsimike wrote:Is it possible to send you a copy of my spreadsheet?
Scroll down a little bit.
Click [Upload attachment]
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
Re: formula
i hope i did this right, this is all new to me.
- Attachments
-
- new FILE001 master sales formula 2-9-19.ods
- (16.38 KiB) Downloaded 77 times
open office 4.1.6
Re: formula
There is no value entered in C1 - you have appended it to the prompt from A1, which overflows into B1 and c1.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: formula
The cell C1 has not contains anything. It is empty. Only the string with a number-like end of the the cell A1 flows into the cell C1. But it is not part or content of the cell C1. The value of an empty cell is 0.
Last edited by Zizi64 on Sat Apr 20, 2019 1:58 pm, edited 1 time in total.
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: formula
Don't bother. Your formulae are set up to use the value in C1. Simply click on C1, then enter 6.75.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS