I have a problem that Im trying to solve but keep coming to a dead end, I
need help on the writing a "IF" formula in excel: it goes like this

A1-"Self" A2-1005.00 A3-1000
A1-"Other" A2-1002.00 A3- 0

if A1 ="Self" and A2 is = 1000 then the value in A3 should be 1000

If A2 is <1000, then the value should equal the value in A2 ie less that
1000...eg... if A2 above was 929, then A3 would reflect 929.

if A1 ="Other" any value in A2( whether greater or less than does not
matter)then A3 should reflect or equal A2

I have sincerely tried the above using if, and and or and somehow i cannot
get through...

please help....if Im not at the right site please guide me through another
site....

thank you livius

also please can you reply to my work address: