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:
> 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($Q12="02";(BR12+BT12+BV12);OM($Q12="03";(BR12+BT12+BV12);"")));"")
> > > >
> > > > Are there any smart persons who can help me?
> > > >
> > > > MR
> > > > Mia
> > > >
|
Similar Threads
