Calculation-problem
Did you test it. For example, a 2 in a cell could be stored as the number 2
or it could be stored as the letter 2.
Then again, maybe you are not having any problems.
--
Regards,
Tom Ogilvy
"Mia" wrote:
(BR12+BT12+BV12)
is not text it´s figures.
//
Mia
"Tom Ogilvy" skrev:
(BR12+BT12+BV12)
will return an error if any of the cells contain Text.
Sum(BR12,BT12,BV12)
would be more robust.
--
Regards,
Tom Ogilvy
"Mia" wrote:
Hello,
I´m been trying to make a calculation but I can´t get it right. I don´t know
the enlish word but in swedish its #värdefel! (value wrong).
=OM($AC12="3";OM($Q12="01";(BR12+BT12+BV12);OM($Q1 2="02";(BR12+BT12+BV12);OM($Q12="03";(BR12+BT12+BV 12);"")));"")
Are there any smart persons who can help me?
MR
Mia
|