hi guys
im hoping some one can give me the answer to a formula that i need
if b1>b2 then put cell a1 into cell d2 but if b2>b1 then put cell a2 into cell d2
regards
hi guys
im hoping some one can give me the answer to a formula that i need
if b1>b2 then put cell a1 into cell d2 but if b2>b1 then put cell a2 into cell d2
regards
D2: =INDEX(A1:A2,1+(B2>B1),1)
or
D2: =IF(B2>B1,A2,A1)
However you don't specify what happens if B1=B2... both of the above assume if B2=B1 then A1 is used in D2.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
thanks donkey
b2 or b1 will never be the same
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks