What formulas can I use in InfoPath?

[Communicado]

I am brand new to InfoPath and need to use formulas in a form. I know
how to do this in excel, but do not know if InfoPath can support excel
formulas. Can I do that? Any advice would be GREATLY appreciated!

 

[Greg Collins]

InfoPath does not use Excel formulas. It uses XPath and XSLT functions...
which are different and there are MUCH less of them.

However, using code, you can accomplish any thing Excel can do -- just not
as quickly and easily as you can in Excel.

 

[Clay Fox]

If you are looking to collect information from others or allow them to
interact with information from other sources then InfoPath is the way to go
and will be a better environment for doing so. However if you are doing
Excel core competencies, running calculations on large data sets than
InfoPath may not be the best.
Making the jump between the two, to create InfoPath forms, is not that
difficult but most of your Excel skills will not be that relevant.