Formula
 

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

--
Regards
YM

Formula
 

=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

"Yitzhack" wrote in message
...
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

--
Regards
YM

Formula
 

that's what i needed. Thanks
--
Regards
YM



"David Biddulph" wrote:

=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

"Yitzhack" wrote in message
...
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

--
Regards
YM