macentrap
asked on
Nested IF statement to compare values in 3 columns
Hi Experts
Would like to implement using IF statement or VBA
If there is value is zero for 2009, 2010,2011 then not used in "3yrs"
if any of them is true would like years' in which used .
IF used in all three years then "High Usage"
or suggestion to bett
data.xls
Would like to implement using IF statement or VBA
If there is value is zero for 2009, 2010,2011 then not used in "3yrs"
if any of them is true would like years' in which used .
IF used in all three years then "High Usage"
or suggestion to bett
data.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You
neothwin - the extra code in my solution was to provide commas and avoid extra spaces!
Thanks, macentrap!
I realise this question is closed, but for the record:
Both
IF(AND(C2<>0,D2<>0,E2<>0)
and
IF(C2*D2*E2>0
can also be expressed with
IF(Countif(C2:E2,">0")
The benefit is speed. It's only one operation as opposed to three comparisons or two multiplications.
cheers, teylyn
Both
IF(AND(C2<>0,D2<>0,E2<>0)
and
IF(C2*D2*E2>0
can also be expressed with
IF(Countif(C2:E2,">0")
The benefit is speed. It's only one operation as opposed to three comparisons or two multiplications.
cheers, teylyn
=IF(SUM(C2:E2)>0,IF(C2*D2*