Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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(OR(AND(A1=1,B1=2),AND(C1=,D1=3)))

becomes

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.

share|improve this question
    
This might help, from StackOverflow - Convert Spreadsheet Formulas to Java. –  rishimaharaj May 23 '12 at 12:05
add comment

1 Answer

As you specify "built in" the answer almost certainly seems to be 'No'.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.