Sep 25 2019 01:34 PM
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.
Sep 25 2019 03:15 PM
As variant in D2 it could be
=IF(REPLACE(C2,1,1,"")+0>=13,"full","")
if I understood you correctly
Sep 25 2019 04:15 PM
@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.
Sep 26 2019 01:38 AM
Sep 26 2019 01:46 AM
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
Sep 26 2019 02:59 AM
@Wyn Hopkins explained in more detail. If our understanding is not correct better if you submit small sample file to illustrate your data.
Oct 03 2019 05:06 PM - edited Oct 03 2019 05:24 PM
Oct 04 2019 07:17 AM
But that's exactly what above formulas do.