So I'm working on a spreadsheet and I ran into some trouble. I can not solve this formula to save my life. Anyone think they can take a crack at it?
In cell H4, insert a Logical Function (nested if, IF and OR functions) to calculate the amount of the donation in cell H4 that will go towards preserving the forest and lake area (by using the OR function you do not need to use a Nested IF Function).
Criteria
- If the Towns are Greenlake OR Clearwater, they have requested that 25% of their Approximate Donations to Date be designated specifically for the preservation of the lake and forest they share.
- Otherwise, the towns of Oakbridge and Chester have requested that 15% of their donations go to this area.
Bookmarks