Formula Needed

[Dwayne6584]

I need a formula that uses different math functions for a result. Example I have avg monthly value in one column next I have a column for daily, weekly, monthly, yearly. Another column will show the result. If a result value is put in daily then the result needs to show avg divided by 30 if a value is entered in monthly say 3 month then result needs to multiply 3 by the avg and so on. Basically a calculator with different math functions based off the value entered into any of the cells. If no value entered in any cell should show 0

 

[PeteWright]

Could you share an example that shows what you need and what you want, eg. column A with the input and column B with the output.