IF formula with double condition

**dreddster** · 04-15-2013, 05:51 AM

Hello guys,

I have this formula
=IF(ABS(H34)+ABS(H38)=ABS(H43); "Equal"; "Not Equal")

However I found that I must adjust it accordingly with another condition.

Basically if H34>0 and H38>0, or if H34<0 and H38<0 - the formula should be =IF(ABS(H34)+ABS(H38)=ABS(H43); "Equal"; "Not Equal")
However if H34>0 and H38<0, or if H34<0 and H38>0 - the formula should be =IF(ABS(H34)-ABS(H38)=ABS(H43); "Equal"; "Not Equal")

Can I do that with some more advanced expression of IF formula, or do I need to use another method to accomplish that?

Thank you in advance!

**Cheeky Charlie** · 04-15-2013, 06:51 AM

Try this:

=IF(H34*H38>=0,IF(H34+H38=H43,"Equal","Not equal"),IF(ABS(34)-ABS(H38)=ABS(H43),"Equal","Not equal"))

Might be adapted depending on how you want to treat zeros.

**dreddster** · 04-15-2013, 07:43 AM

It works great! I adjusted it a little, however I found another issue. It doesn't give me proper valuation, and I think I found the reason. One of the amounts in the calculation is 50 345.32
However if I increase the decimal point to 10, it appears as 50345.3200000834. How do I make excel ignore any digit after the second decimal ?

P.S.: I included ROUND and it is working now. Thank you for your help!

IF formula with double condition

LinkBack

Thread Tools

Rate This Thread

Display

IF formula with double condition

Re: IF formula with double condition

Re: IF formula with double condition

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions