Prev: Sum in a column if there are 3 conditions in another column
Next: How to retain part of formula's criteria as static
From: casdaq on 21 May 2010 12:10
I have this formula currently set up...

=VLOOKUP($A14,$B$7:$J$10,5)*W14

but I needit to not reflect the calculation if W14 has a "-" dash in the
cell. I've attempted to add in a If formula to this but it isn't working out.

Any sugguestions are greatly appreciated.
From: Don Guillett on 21 May 2010 12:19
By "-" do you mean a minus number or an actual dash??
if(w14<0,"",doyourthing)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"casdaq" <casdaq(a)discussions.microsoft.com> wrote in message
news:123F94A8-9D83-4159-B642-070D684CB3A5(a)microsoft.com...
>I have this formula currently set up...
>
> =VLOOKUP($A14,$B$7:$J$10,5)*W14
>
> but I needit to not reflect the calculation if W14 has a "-" dash in the
> cell. I've attempted to add in a If formula to this but it isn't working
> out.
>
> Any sugguestions are greatly appreciated.

From: Ron on 21 May 2010 13:01
Try:
=IF(W14<=0,"",VLOOKUP($A14,$B$7:$J$10,5)*W14)

"casdaq" wrote:

> I have this formula currently set up...
>
> =VLOOKUP($A14,$B$7:$J$10,5)*W14
>
> but I needit to not reflect the calculation if W14 has a "-" dash in the
> cell. I've attempted to add in a If formula to this but it isn't working out.
>
> Any sugguestions are greatly appreciated.
From: casdaq on 21 May 2010 13:34
THANK YOU THANK YOU THANK YOU!! That worked out perfactly!

"Ron(a)Buy" wrote:

> Try:
> =IF(W14<=0,"",VLOOKUP($A14,$B$7:$J$10,5)*W14)
>
> "casdaq" wrote:
>
> > I have this formula currently set up...
> >
> > =VLOOKUP($A14,$B$7:$J$10,5)*W14
> >
> > but I needit to not reflect the calculation if W14 has a "-" dash in the
> > cell. I've attempted to add in a If formula to this but it isn't working out.
> >
> > Any sugguestions are greatly appreciated.
From: jayray on 21 May 2010 15:37
On May 21, 12:10 pm, casdaq <cas...(a)discussions.microsoft.com> wrote:
> I have this formula currently set up...
>
> =VLOOKUP($A14,$B$7:$J$10,5)*W14
>
> but I needit to not reflect the calculation if W14 has a "-" dash in the
> cell. I've attempted to add in a If formula to this but it isn't working out.
>
> Any sugguestions are greatly appreciated.

Put SUM(W14) instead of just W14.
 | 
Pages: 1
Prev: Sum in a column if there are 3 conditions in another column
Next: How to retain part of formula's criteria as static