Hi all.
A little help if you dont mind.
I have this
=LOOKUP(D3,{0,6,12,24,36,48,49},{1000,600,400,200,100,0})
to do some scoring
However when the cell is blank (D3) ie no data in there i need the score to show 0 at the moment it shows 1000
I cant for the life of me get it right.
Any help greatly appreciated.
Stret.
A little help if you dont mind.
I have this
=LOOKUP(D3,{0,6,12,24,36,48,49},{1000,600,400,200,100,0})
to do some scoring
However when the cell is blank (D3) ie no data in there i need the score to show 0 at the moment it shows 1000
I cant for the life of me get it right.
Any help greatly appreciated.
Stret.