Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yitzhack - 31 Jul 2008 04:33 GMT

I'm working on a project where I'm calculating the number of weeks per
quarter. What a need is a formula where 40=p, 80=pp 120=ppp and finally
160=pppp. Is that even possible?

Thanks

Signature

Regards
YM

Reply to this Message

David Biddulph - 31 Jul 2008 08:29 GMT

=IF(A2=40,"p",IF(A2=80,"pp",IF(A2=120,"ppp",IF(A2=160,"whatever answer you
want if A2 isn't any of the numbers you quoted"))))

Another approach, depending on how you wish to treat your undefined cases,
might be =REPT("p",MIN(A2/40,4))
--
David Biddulph

> I'm working on a project where I'm calculating the number of weeks per
> quarter. What a need is a formula where 40=p, 80=pp 120=ppp and finally
> 160=pppp. Is that even possible?
>
> Thanks

Reply to this Message

Yitzhack - 01 Aug 2008 00:31 GMT

that's what i needed. Thanks

Signature

Regards
YM

> =IF(A2=40,"p",IF(A2=80,"pp",IF(A2=120,"ppp",IF(A2=160,"whatever answer you
> want if A2 isn't any of the numbers you quoted"))))
[quoted text clipped - 9 lines]
> >
> > Thanks

Reply to this Message