Home

need help with a fonction

%3CLINGO-SUB%20id%3D%22lingo-sub-875585%22%20slang%3D%22en-US%22%3Eneed%20help%20with%20a%20fonction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875585%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20my%20problem%20is%20this%20one%2C%20i%20have%20been%20trying%20to%20make%20two%20collumn%20react%20to%20each%20other%20so%20the%20first%20one%20when%20the%20entry%20%2F13%20and%20higher%20is%20entered%20the%20second%20collumn%20shows%20the%20entry%20full.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20been%20trying%20to%20use%20the%20SI%20function%20but%20i%20can't%20seem%20to%20be%20able%20to%20have%20the%20%2F%20register%20it%20gives%20me%20an%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20formula%20i%20am%20trying%20to%20do%20here%20is%20when%20C2%20%3D%20%2F13%20and%20higher%20D2%20%3D%20full%20and%20if%20C2%20is%20%2F12%20and%20lower%20D2%20his%20blank%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20your%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-875585%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-875784%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20with%20a%20fonction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875784%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20you%20say%20%2F13%20what%20do%20you%20mean%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-875789%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20with%20a%20fonction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875789%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415291%22%20target%3D%22_blank%22%3E%40ssanscartier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20in%20D2%20it%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(REPLACE(C2%2C1%2C1%2C%22%22)%2B0%26gt%3B%3D13%2C%22full%22%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eif%20I%20understood%20you%20correctly%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-875879%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20with%20a%20fonction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875879%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3Ei%20have%20tried%20this%20but%20it%20comes%20back%20has%20an%20error%2C%20the%20%2F13%20the%20total%20amount%20of%20people%20registered%20for%20the%20session%20and%20i%20want%20an%20indication%20that%20the%20class%20is%20full%20on%20the%20next%20collumn%2C%20i%20have%20the%20feeling%20i%20will%20have%20to%20get%20rid%20of%20the%20%2F%20in%20order%20for%20this%20to%20work.%20unless%20i%20find%20a%20way%20to%20make%20it%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876500%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20with%20a%20fonction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876500%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415291%22%20target%3D%22_blank%22%3E%40ssanscartier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20explain%20the%20%2F13%20please%20-%20I%20don't%20understand%20the%20%2F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876506%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20with%20a%20fonction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876506%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415291%22%20target%3D%22_blank%22%3E%40ssanscartier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you're%20number%20is%20entered%20per%20the%20attached%20screenshot%20then%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E's%20answer%20should%20work%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20665px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133596iF2AFDBEA235E2C1D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20REPLACE%20removes%20the%201st%20character%20(the%20%2F%20)%20with%20a%20space.%3C%2FP%3E%0A%3CP%3EThe%20%2B0%20then%20turns%20that%20into%20a%20number%3C%2FP%3E%0A%3CP%3EThe%20IF%20then%20checks%20if%20the%20number%20is%20%26gt%3B%3D13%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWyn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876642%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20with%20a%20fonction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876642%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415291%22%20target%3D%22_blank%22%3E%40ssanscartier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3Bexplained%20in%20more%20detail.%20If%20our%20understanding%20is%20not%20correct%20better%20if%20you%20submit%20small%20sample%20file%20to%20illustrate%20your%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-892613%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20with%20a%20fonction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-892613%22%20slang%3D%22en-US%22%3EThanks%20i%20will%20try%20to%20explain%20a%20bit%20better.%20This%20is%20for%20group%20managing%2C%3CBR%20%2F%3E%3CBR%20%2F%3EBasicaly%20when%20the%20number%20in%20the%20culumn%20J%20is%20%2F13%20and%20over%20i%20need%20the%20next%20culumn%20K%20to%20display%20full%20but%20when%20the%20J%20culumn%20display%20%2F12%20and%20lower%20the%20culumn%20K%20needs%20to%20be%20empty.%20This%20is%20to%20keep%20track%20of%20the%20full%20groups%20and%20thos%20that%20still%20have%20places%20for%20more%20to%20join.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20clarifies%20a%20bit%20more.%20Sorry%20i%20have%20a%20bit%20of%20trouble%20explaining%20this.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-893452%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20with%20a%20fonction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-893452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415291%22%20target%3D%22_blank%22%3E%40ssanscartier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBut%20that's%20exactly%20what%20above%20formulas%20do.%3C%2FP%3E%3C%2FLINGO-BODY%3E
ssanscartier
New Contributor

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

 

thanks for your time.

8 Replies
Hi

When you say /13 what do you mean?

@ssanscartier 

As variant in D2 it could be

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

if I understood you correctly

@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.

Hi @ssanscartier 

 

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

@ssanscartier 

 

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

 

image.png

 

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

@ssanscartier 

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

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.

@ssanscartier 

But that's exactly what above formulas do.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies