What IF statement
in [Microsoft Office]
|
From: Beep Beep on 25 Mar 2010 20:11 Here is what I would like to do: Don't know if an IF statement will suffice here or not: In column H I either have S1,000 or it is blank Column J is blank What I would do is if H(?) = $1,000 and L (?) is > than 100% then put $1,500 in Column J Also if H(?) is blank and L(?) is > 100% put $2,500 in Column J However if l(?) is <100% put zero in Column J
From: macropod on 25 Mar 2010 21:03 Presumably this is for Excel. Given your specs, the following formula works for values in H1 & L1: =(H1<>0)*(L1>100%)*1500+(H1=0)*(L1>100%)*2500 You don't say what should happen when L = 100%. Note: As coded, H tests for either zero or any non-zero value. -- Cheers macropod [Microsoft MVP - Word] "Beep Beep" <BeepBeep(a)discussions.microsoft.com> wrote in message news:C38A809C-9556-4643-8CDA-517694B19296(a)microsoft.com... > Here is what I would like to do: Don't know if an IF statement will suffice > here or not: > In column H I either have S1,000 or it is blank > Column J is blank > What I would do is if H(?) = $1,000 and L (?) is > than 100% then put $1,500 > in Column J > Also if H(?) is blank and L(?) is > 100% put $2,500 in Column J > However if l(?) is <100% put zero in Column J >
|
Pages: 1 Prev: Changing columns on same page Next: Ofice Home and Student 2007 |