[Solved] Need help with my formula

[edurant03]

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!

[robleyd]

G'day and welcome to the forum.

The syntax for the IF function is:

Code: Select all

IF(Test; ThenValue; OtherwiseValue)

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.

[edurant03]

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.

[robleyd]

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.

[RusselB]

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

Simply repeat the 'Entry Form' .I12 as the 3rd parameter in your IF

Is there such a way to pull actual data from another sheet and have and IF function also? Thank you in advance!

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 Form

[edurant03]

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.

[RusselB]

Code: Select all

=IF('Entry Form' .I12=0; "ND";'Entry Form' .I12)

[edurant03]

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!

[Zizi64]

I tried that first but had the "" around entry form so it didnt work and I thought there was more to it.

You has used space character in the name of the sheet.
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.