Nested If Question

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

I am trying to write a nested if that does the
following...

If H2<=3 and C2="Buy" and A2="B" then K2+.15 OR
If H2<=3 and C2="Sell" and A2="B" then J2-.15 OR
If H2>3 and C2="Buy" and A2="B" then K2+.30 OR
If H2>3 and C2="Sell" and A2="B" then J2-.30

Thanks in Advance
 
I don't know if you'll have luck getting someone to do that whole thing for
you, it's just tedious grunt work (i.e. no fun).
start like

=IF(AND(H2<=3,C2="Buy",A2="B"),K2+15,IF(.........


The OR you are using is not going to be the OR used by excel. They are
replaced by the nested IF functions you inquire about.
 
Back
Top