Highlighted
New Contributor

# need help with a fonction

hi my problem is this one, i have been trying to make two collumn react to each other so the first one when the entry /13 and higher is entered the second collumn shows the entry full.

i have been trying to use the SI function but i can't seem to be able to have the / register it gives me an error.

the formula i am trying to do here is when C2 = /13 and higher D2 = full and if C2 is /12 and lower D2 his blank

8 Replies
Highlighted

# Re: need help with a fonction

Hi

When you say /13 what do you mean?
Highlighted

# Re: need help with a fonction

As variant in D2 it could be

``=IF(REPLACE(C2,1,1,"")+0>=13,"full","")``

if I understood you correctly

Highlighted

# Re: need help with a fonction

@Sergei Baklani have tried this but it comes back has an error, the /13 the total amount of people registered for the session and i want an indication that the class is full on the next collumn, i have the feeling i will have to get rid of the / in order for this to work. unless i find a way to make it work.

Highlighted

# Re: need help with a fonction

Can you explain the /13 please - I don't understand the /

Highlighted

# Re: need help with a fonction

If you're number is entered per the attached screenshot then @Sergei Baklan's answer should work

The REPLACE removes the 1st character (the / ) with a space.

The +0 then turns that into a number

The IF then checks if the number is >=13

Wyn

Highlighted

# Re: need help with a fonction

@Wyn Hopkins explained in more detail. If our understanding is not correct better if you submit small sample file to illustrate your data.

Highlighted

# Re: need help with a fonction

Thanks i will try to explain a bit better. This is for group managing,

Basicaly when the number in the culumn J is /13 and over i need the next culumn K to display full but when the J culumn display /12 and lower the culumn K needs to be empty. This is to keep track of the full groups and thos that still have places for more to join.

Hope this clarifies a bit more. Sorry i have a bit of trouble explaining this.
Highlighted

# Re: need help with a fonction

But that's exactly what above formulas do.