Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions |