Formula

Y

Yitzhack

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
 
D

David Biddulph

=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))
 
Y

Yitzhack

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



David Biddulph said:
=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))
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic sorting (giving max and min) based on custom sorting lis 4
Display weeks from a Milestone 0
Function help 7
How do I search a worksheet for a custom "text" max and min value 1
How to have a drop down selection list 0
Sumproduct across mutliple columns 3
Help with a formula for a Time Sheet. 1
Work Budget Salary vs Real Time Salary 0

Top