Search results

Narayan, that's it! I knew it was simple, but my brain doesn't want to work today. Mark this as solved!

I have a simple problem. Say I have a range of cells with some numbers B1:D1 I want to only add the cells if the cells below contain a number B2:D2 I know I can write a simple formula =If(B2<>0,B1,0)+If(C2<>0,C1,0)... That gets to be too long if my range is B1:Z1! I know...

I just solved it, how did you know? =REPT(REPT("I",B2/(B2/5))&" ",B2/5)&REPT("I",MOD(B2,5))

SirJB7 We are on the right path. I want always to only have 5 I's and then a space. so if a cell has 13 it would look like IIIII IIIII III

Would it be possible to add a separator in the rept function so that my data would show 5 I's then a space, then 5 more I's? =rept("I",10) IIIII IIIII instead of IIIIIIIIII

You will need a another cell so that you see minute formats. If you want E12 to show minutes put in this formula in E =D12/(24*60). You would then enter in your number in D12 and set custom format to mm:ss.

I have an easy solution for you if you would like me to email you the file.

I began my new job as an analyst at a small financial's call center. I had only a basic understanding of excel, but with the help of this site I have learned something(s) every day! In just 4 months I am amazed by how much I have already gained from this site. The formula examples are incredibly...

You could just input a number or letter into the cells that you are working and use conditional formating to make the cells red or green. Make the number or letter the same color and you will only see the color. That way you can use the =Count() formula. Hope this helps.