ExcelBanter - I need help with Excel formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I need help with Excel formula (https://www.excelbanter.com/excel-discussion-misc-queries/251859-i-need-help-excel-formula.html)

I need help with Excel formula

I need help with Excel formula (first one is correct but I don't know how to
add second formula)?
=IF('1'!W16="($E202000000,0,IF($E20100€¦ =""AB8",'1'!W16) or
=IF(€˜1!X16="(($E205000000,1200,IF($E20€¦ =""AB8",'1'!X16)

--
Thx

I need help with Excel formula

On Sat, 26 Dec 2009 06:31:01 -0800, antoinette wrote:

I need help with Excel formula (first one is correct but I don't know how to
add second formula)?
=IF('1'!W16="($E202000000,0,IF($E20100… =""AB8",'1'!W16) or
=IF(‘1’!X16="(($E205000000,1200,IF($E20… =""AB8",'1'!X16)

You would just replace the value_if_false argument with your second IF.

=IF('1'!W16="($E202000000,0,IF($E20100… =""AB8",'1'!W16,
IF('1'!X16="(($E205000000,1200,IF($E20… =""AB8",'1'!X16))

However, you have an apparent typo in your second formula. Note that the first
one (1) is ‘1’ (1 surrounded by left and right single quotation marks) and
it should be '1' (1 surrounded by apostrophe's)
--ron