Auto Hot Key AHK script needed.

I use AHK to automate a simple task within an inventory program I use. I need someone to help me with the script to do the following. If cell inside inventory program is > 50.00, then change another cell to a certain value from a pull down list. and If cell > 50, play audio file (beep) If cell1 < 2 and cell2 > 3 play audio file and press {F4} and so on. Nothing to complex, but out of my reach. You will need to help build the script and then let me test it, troubleshoot any issues and make it perfect. The program I use is not available anywhere, but we could arrange a remote session or you can walk me through how to give you the info you need. I would prefer this be AHK so that I can better learn and tweak the script in the future.