formulas with <>
in [General]
|
From: Lynn on 13 Jan 2010 11:44 Hi - I am using a spreadsheet with formulas setup by someone else and the formula is reading: =if (AA110<>"",AA110,if (g110<10,G110,AA110*10)) My interpretation is that it should read: =if(AA110="",AA110 etc. (ie. if AA110 has nothing in it, make the cell blank) Or does the <> mean something else? There is more in the formula but it refers to sheets that do not exist in this workbook thus I presume are disregarded so if AA110 does have something in it, the formula then does the 2nd if statement. Hoping someone can clarify! Thanks
From: Roger Govier on 13 Jan 2010 12:04 Hi Lynn <> means NOT equal to So what the formula says (in words) is If AA110 is not empty then use the value from AA110 otherwise if G110 is less than 10, take the value in G110 or else take the value in AA110 multiplied by 10 -- Regards Roger Govier "Lynn" <Lynn(a)discussions.microsoft.com> wrote in message news:09714510-522A-4F34-860C-E31E07B00485(a)microsoft.com... > Hi - I am using a spreadsheet with formulas setup by someone else and the > formula is reading: > =if (AA110<>"",AA110,if (g110<10,G110,AA110*10)) > My interpretation is that it should read: > =if(AA110="",AA110 etc. (ie. if AA110 has nothing in it, make the cell > blank) > > Or does the <> mean something else? > > There is more in the formula but it refers to sheets that do not exist in > this workbook thus I presume are disregarded so if AA110 does have > something > in it, the formula then does the 2nd if statement. > Hoping someone can clarify! > Thanks > > __________ Information from ESET Smart Security, version of virus > signature database 4767 (20100113) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __________ Information from ESET Smart Security, version of virus signature database 4767 (20100113) __________ The message was checked by ESET Smart Security. http://www.eset.com
|
Pages: 1 Prev: Tracking history of Office files chronologically Next: FORMAT FOR FEET AN DINCHES |