Question about an Excel formula.

Xarpolis · Jul 22, 2015

Ok, I have a question about making a formula in Excel.

I'm trying to write a formula that will make my life easier. I want it to look at cell C11 and see if it's 0-3. If so, type White. If 4-15 type Green, if 16-63 type Blue, if 64-255 type Purple if 256-1023 type Orange if 1024 and over type Yellow.

Any idea how I would make it do that? Thanks in advance!

Alkorin · Jul 23, 2015

You didn't account for less than 0, so I left the cell blank in that case:

=IF(C11<0,"",IF(AND(C11>=0,C11<=3),"White",IF(AND( C11>=4,C11<=15),"Green",IF(AND(C11>=16,C11<=63),"B lue",IF(AND(C11>=64,C11<=255),"Purple",IF(AND(C11> =256,C11<=1023),"Orange","Yellow"

I'm sure there's a more elegant way to do it, but this one works.

Xarpolis · Jul 23, 2015

Thanks, but it doesn't appear to work. Oh well, back to the drawing board. As of right now it's just a box that says the entire formula.

Does it matter if C11 is a formula in and of itself, adding up a few previous columns?
Oh, I'm using Excel 2007.

k^M · Jul 23, 2015

Xarpolis_sl said:
Thanks, but it doesn't appear to work. Oh well, back to the drawing board. As of right now it's just a box that says the entire formula.

Does it matter if C11 is a formula in and of itself, adding up a few previous columns?
Oh, I'm using Excel 2007.

Not sure if it does in 2007 but in 2010/2013 it shouldnt, no. It'll just take whatever that cell totals up to and bases it off that.

The formula Alkorin posted should work I think there may just be an extra spaces in it, apart from that the logic looks good

readmorepostless_sl · Jul 23, 2015

Xarpolis_sl said:
Thanks, but it doesn't appear to work. Oh well, back to the drawing board. As of right now it's just a box that says the entire formula.

Does it matter if C11 is a formula in and of itself, adding up a few previous columns?
Oh, I'm using Excel 2007.

Sounds like excel decided it knows better than you and the cell is formatted as text. Try changing it to General and see if it works.

*edit* To clarify, the formula provided, not C11

ToeMissile · Jul 23, 2015

After you change it to general, click in the formula bar and then hit enter. Otherwise it won't update all the way or something.

Alkorin · Jul 24, 2015

Yep, it works fine, I tried it before I posted. Sounds like a cell formatting issue.

Search

Question about an Excel formula.

Xarpolis

Life's a Dream

Chancellor Alkorin

Part-Time Sith

Xarpolis

Life's a Dream

k^M

Blackwing Lair Raider

readmorepostless_sl

shitlord

ToeMissile

Pronouns: zie/zhem/zer

Chancellor Alkorin

Part-Time Sith