I found a formula that will validate if the IP address that I enter in a cell is correct:
However, I this validation is only for the ip address (for example, 192.168.1.1).
Please Login or Register to view this content.
I need to validate the user is entering the correct IP with subnet information (for example, 192.168.1.1/24).
Is there a way to modify this validation to look for the subnet cdr at the end of the IP? (/32, /31, /30..... /1).