if-or-and question

[wpryan]

I'm trying to get a formula to work:
What it's intended to do is, if the values of G8 and G7 are the same, and the value of I9 is less than I7, then to calculate the difference of I7 from I9 and to add the value of I6. If the values of G8 and G7 are the same and the value of I9 is greater than I7, to subtract 4000 from I9 and add I6. The last condition is to simply put the value 0 as the result. I can't seem to get this to work... I tried to put the code in the message text but the system is stripping out half of it! It seems that the system doesn't like the "greater than" or "less than" symbols... I'll try it this way:

=IF(OR(AND(G8=G7,I9"less than"I7)),I7-I9+I6,IF(OR(AND(G8=G7,I9"greater than"I7)),4000-I9+I6,0))

Thanks in advance.

 

[Sal Paradise]

This will do the following.

If G8 is the same as G7 AND I9 is less than I7
Then Subtract I9 from I7 and add I6

If G8 is the same as G7 AND I9 is greater than I7
Then subtract I9 from 4000 and add I6

If G8 does not equal G7, or if I9 equals I7,
Then 0

=IF(AND(G8=G7,I9<I7),I7-I9+I6,IF(AND(G8=G7,I9>I7),4000-I9+I6,0))

 

[Coryj5]

this one worked for me just fine.

=IF(AND(G7=G8,I9<I7),(I7-I9),IF(AND(G7=G8,I9>I7),(I9-4000)+I7,))

 

[Sal Paradise]

For less than signs, they get interpreted as HTML, so you should write &*l*t*;
Likewise, greater than signs should be written as &*g*t*;

(Remove the *)

 

[Coryj5]

last try...

=IF(AND(G7=G8,I9<I7),(I7-I9+I6),IF(AND(G7=G8,I9>I7),(I9-4000)+I6,))

 

[Coryj5]

Thanks Sal =D

 

[Peter_SSs]

Alternatively, you can just put a space after the < sign, like this

=IF(AND(G7=G8,I9< I7),(I7-I9),IF(AND(G7=G8,I9>I7),(I9-4000)+I7,))

Also, following your 'Report' I have removed some of those failed posts.

 

[wpryan]

Thanks all for your help.