| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
