Jump to content
Sign in to follow this  
L

Fao: Excel Heads

Recommended Posts

Basically i've got a column where in each cell the value is between 0 and 3, I want to make it so that excel adds all the values together which is simple right..?The only thing is, i want it to count a 3 as 2 so that0 = 01 = 12 = 23 = 2How the f*ck do i do that?

Share this post


Link to post
Share on other sites

i really tried but i cant work it out, the only thing i can think of is this=SUBSTITUTE(A4,"3","2", 1)if u have your column0123create another column next to it, but this column will substitute the number 3 with a 2, so u'll have this0 01 12 23 2then u can use the second column to do whatever and just hide it

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×