Hi there @Tony105,
welcome to KNIME Community!
Agree with @aworker. Also if you explain formula with words it could help. Not everybody is Excel fan 
You can check this topic as it is similar and additionally here is book that can ease transition from Excel:
https://www.knime.com/knimepress/download-from-excel-to-knime
Hope this helps!
Br,
Ivan