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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies