[Solved)] IF() Formula

Discuss the spreadsheet application

[Solved)] IF() Formula

Postby bulsimike » Sat Apr 20, 2019 9:45 am

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

Re: formula

Postby RoryOF » Sat Apr 20, 2019 9:53 am

/View /Value highlighting, to check if your values are numeric or text.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29432
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: formula

Postby bulsimike » Sat Apr 20, 2019 10:27 am

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

Re: formula

Postby RoryOF » Sat Apr 20, 2019 10:36 am

Numbers will be blue, text black, and formulas in green.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29432
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: formula

Postby bulsimike » Sat Apr 20, 2019 10:45 am

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

Postby bulsimike » Sat Apr 20, 2019 10:53 am

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

Re: formula

Postby Villeroy » Sat Apr 20, 2019 11:11 am

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: formula

Postby Zizi64 » Sat Apr 20, 2019 11:35 am

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; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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
Zizi64
Volunteer
 
Posts: 8209
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: formula

Postby Villeroy » Sat Apr 20, 2019 11:45 am

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: formula

Postby bulsimike » Sat Apr 20, 2019 12:11 pm

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

Re: formula

Postby RoryOF » Sat Apr 20, 2019 12:19 pm

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.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29432
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: formula

Postby Zizi64 » Sat Apr 20, 2019 12:25 pm

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; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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
Zizi64
Volunteer
 
Posts: 8209
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: formula

Postby bulsimike » Sat Apr 20, 2019 12:29 pm

how do i apply A1 to I4 ???????
open office 4.1.6
bulsimike
 
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am

Re: formula

Postby RoryOF » Sat Apr 20, 2019 12:32 pm

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.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29432
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: formula

Postby bulsimike » Sat Apr 20, 2019 12:43 pm

: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

Postby bulsimike » Sat Apr 20, 2019 12:45 pm

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

Re: formula(SOLVED)

Postby bulsimike » Sat Apr 20, 2019 12:49 pm

thank you
open office 4.1.6
bulsimike
 
Posts: 9
Joined: Sat Apr 20, 2019 9:14 am


Return to Calc

Who is online

Users browsing this forum: Agalloch, Zizi64 and 30 guests