Calculation-problem

[Mia]

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($Q12="02";(BR12+BT12+BV12);OM($Q12="03";(BR12+BT12+BV12);"")));"")

Are there any smart persons who can help me?

MR
Mia

 

[Tom Ogilvy]

(BR12+BT12+BV12)

will return an error if any of the cells contain Text.

Sum(BR12,BT12,BV12)

would be more robust.

 

[Mia]

(BR12+BT12+BV12)

is not text it´s figures.

//
Mia



"Tom Ogilvy" skrev:

 

[Tom Ogilvy]

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.

 

[Mia]

Thank you!

I made following change in the BT12-cell

from
=OM($Q12="01";$AF12*((Dataunderlag!$H$13-$U12+1)/Dataunderlag!$H$13);"")

to
=OM($Q12="01";$AF12*((Dataunderlag!$H$13-$U12+1)/Dataunderlag!$H$13);"0")

So everything works, thanks!

//
Mia




"Tom Ogilvy" skrev: