[Solved] Need help with my formula
[Solved] Need help with my formula
I have two sheets, the first I enter data into a cell say "B2" called "Entry Form", that gets calculated into another cell "I12", the results then are displayed in a cell on the second sheet which has the formula of ='Entry Form' .I12 giving me my results.
Now my objective is to set an IF,OR,ELSE etc function that would display "ND" if the ='Entry Form' .I12 results were equal to 0 and if the results were greater than 0 I need the cell to display as it normally would with the data from ='Entry Form' .I12
I have figured out the formula to populate =IF('Entry Form' .I12=0; "ND") so that it will populate ND but I can't figure out how to have the normal values display as they would if not 0
Is there such a way to pull actual data from another sheet and have and IF function also? Thank you in advance!
Now my objective is to set an IF,OR,ELSE etc function that would display "ND" if the ='Entry Form' .I12 results were equal to 0 and if the results were greater than 0 I need the cell to display as it normally would with the data from ='Entry Form' .I12
I have figured out the formula to populate =IF('Entry Form' .I12=0; "ND") so that it will populate ND but I can't figure out how to have the normal values display as they would if not 0
Is there such a way to pull actual data from another sheet and have and IF function also? Thank you in advance!
Last edited by robleyd on Sat Jul 14, 2018 3:14 am, edited 1 time in total.
Reason: Tagged [Solved] [robleyd, Moderator]
Reason: Tagged [Solved] [robleyd, Moderator]
END OpenOffice 4.1.3
Re: Need help with my formula
G'day and welcome to the forum.
The syntax for the IF function is:
You have =IF('Entry Form' .I12=0; "ND") where 'Entry Form' .I12=0 is the Test and "ND" is the ThenValue. You simply need to add the third argument to the IF function; that is, what you want to display for the OtherwiseValue when 'Entry Form' .I12 is not zero.
You haven't mentioned if you need to deal differently with a value less than zero.
The syntax for the IF function is:
Code: Select all
IF(Test; ThenValue; OtherwiseValue)
You haven't mentioned if you need to deal differently with a value less than zero.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Re: Need help with my formula
Hi thank you for responding, I did that but the problem I am having is it displays the actual wording "'Entry Form' .I12" instead if displaying the data or actual values from the entry form sheet. There will not be values less then 0, just 0 and greater.
END OpenOffice 4.1.3
Re: Need help with my formula
Can you upload a sample spreadsheet file showing the problem?
[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here. The link also contains information on how to anonymise your document if it contains confidential information.
[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here. The link also contains information on how to anonymise your document if it contains confidential information.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Re: Need help with my formula
Simply repeat the 'Entry Form' .I12 as the 3rd parameter in your IFedurant03 wrote:I have figured out the formula to populate =IF('Entry Form' .I12=0; "ND") so that it will populate ND but I can't figure out how to have the normal values display as they would if not 0
Yes you can... in fact you are starting to do that already by having a named sheet. You just have to remember to specify the sheet name, which you have done in your formula by referencing the sheet named Entry Formedurant03 wrote:Is there such a way to pull actual data from another sheet and have and IF function also? Thank you in advance!
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: Need help with my formula
Could you give me an example? Would I be entering something along the lines of =IF('Entry Form' .I12=0; "ND"); IF('Entry Form' .I12>0; "'Entry Form' .I12")
I did that before and it would give me the actual statement Entry Form where my data would be.
I did that before and it would give me the actual statement Entry Form where my data would be.
END OpenOffice 4.1.3
Re: Need help with my formula
Code: Select all
=IF('Entry Form' .I12=0; "ND";'Entry Form' .I12)
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: Need help with my formula
It worked!!! So simple lol I tried that first but had the "" around entry form so it didnt work and I thought there was more to it. OMG Thank you!
END OpenOffice 4.1.3
Re: [Solved] Need help with my formula
You has used space character in the name of the sheet.I tried that first but had the "" around entry form so it didnt work and I thought there was more to it.
You need apostrophes around the sheet name only in such special cases.
Do not use white spaces in a name of a sheet. Use _ character instead.
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.