taffmorgan7274
New Member
- Joined
- Aug 29, 2021
- Messages
- 14
- Office Version
- 365
- Platform
- MacOS
I have a problem wherein I have 3 different answers for whatever appears in a single cell.
The cell which is the target cell is AE13 and the function cell is AD3
In the first instance if AE13l is less than 121 then the target cell should return a sum of 720
In the next IF function, if AE31 >120 and <171 the sum returned should be 825
In the final IF function, if AE31 >220 the sum returned is 900
How can I achieve this in a single formula?
The cell which is the target cell is AE13 and the function cell is AD3
In the first instance if AE13l is less than 121 then the target cell should return a sum of 720
In the next IF function, if AE31 >120 and <171 the sum returned should be 825
In the final IF function, if AE31 >220 the sum returned is 900
How can I achieve this in a single formula?