I need help with Excel formula

  • Thread starter Thread starter antoinette
  • Start date Start date
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)
 
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
 
Back
Top