Dwayne6584
New Member
- Joined
- Aug 6, 2014
- Messages
- 12
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