I am currently using excel to simulate some hardware control logic for a processor (for a class). I am only using four formulae: If(), Or(), And() and string operations MID(). I am trying to convert these nested excel formulas into C/Java style syntax. eg:
if((A1 == 1 && B1 == 2)||(C1 == 1 && D1 == 2))
Does excel have any built in converters for such purpose?
I know that it is possible using complex regex, but I much rather find a simpler approach for this issue.