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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
=IF(SUM(C2:E2)>0,IF(C2*D2*