[Solved)] IF() Formula

Discuss the spreadsheet application
Post Reply
bulsimike
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am

[Solved)] IF() Formula

Post by bulsimike »

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
open office 4.1.6
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: formula

Post by RoryOF »

/View /Value highlighting, to check if your values are numeric or text.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
bulsimike
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am

Re: formula

Post by bulsimike »

RoryOF wrote:/View /Value highlighting, to check if your values are numeric or text.
iam assuming they are numeric, turned blue and red, ????
open office 4.1.6
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: formula

Post by RoryOF »

Numbers will be blue, text black, and formulas in green.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
bulsimike
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am

Re: formula

Post by bulsimike »

RoryOF wrote:Numbers will be blue, text black, and formulas in green.
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, mike :crazy:
open office 4.1.6
bulsimike
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am

Re: formula

Post by bulsimike »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: formula

Post by Villeroy »

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
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: formula

Post by Zizi64 »

I have open office 4.1.6 , My system is windows 7, when i signed up the only option was oo3.1
In the Header of this forum - User Control Panel - Porfile (TAB) - Edit signature (SubTAB): Just edit the text of your signature.
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.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: formula

Post by Villeroy »

bulsimike wrote:Is it possible to send you a copy of my spreadsheet?
Hit the [Post Reply] button, not [Quick Reply].
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
bulsimike
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am

Re: formula

Post by bulsimike »

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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: formula

Post by RoryOF »

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
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: formula

Post by Zizi64 »

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.
bulsimike
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am

Re: formula

Post by bulsimike »

how do i apply A1 to I4 ???????
open office 4.1.6
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: formula

Post by RoryOF »

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
bulsimike
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am

Re: formula

Post by bulsimike »

:bravo: Thank You, That Solved All My Headbanging :bravo:
open office 4.1.6
bulsimike
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am

Solved

Post by bulsimike »

Thanks Guys
open office 4.1.6
bulsimike
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am

Re: formula(SOLVED)

Post by bulsimike »

thank you
open office 4.1.6
Post Reply