Hi Lee,

Perhaps:
=IF(A1="Other",A2,IF((A1="Self")*(A2=1000)=0,A2,1 000))
but you haven't full explained the logic. For example, what is supposed to happen if A1 is neither "Other" nor "Self"? If it can
only be "Other" or "Self", the formula could be reduced to:
=IF(A1="Other",A2,IF(A2=1000,A2,1000))
but the 'correct' answer depends on which condition(s) take precedence.

--
Cheers
macropod
[MVP - Microsoft Word]


"lee" wrote in message ...
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: