I need help with Excel formula

A

antoinette

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

Ron Rosenfeld

I need help with Excel formula (first one is correct but I don't know how to
add second formula)?
=IF('1'!W16="($E20>2000000,0,IF($E20>100… =""AB8",'1'!W16) or
=IF(‘1’!X16="(($E20>5000000,1200,IF($E20… =""AB8",'1'!X16)
Click to expand...

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

=IF('1'!W16="($E20>2000000,0,IF($E20>100… =""AB8",'1'!W16,
IF('1'!X16="(($E20>5000000,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
 
Top