Forum Discussion
Solved
Help on how to write formulas within a cell with multiple conditions
First Formula Help needed: How do I write a formula that would give me the following: If mileage on a cell (G10 in this case) is 0-75 miles, enter $0, if mileage is 76-100 enter $250, if mileage is...
1) =IFS(G10<=75, 0, G10<=100, 250, G10<150, 350, G10<=200, 500)
This formula will return #N/A if G10 is larger than 200.
2) =IF(G12<750, 750, 0)
3) =IFS(G7<=2, 0, G7=3, 1, G7=4, 2, G7>=5, 2.5)*G9
1) =IFS(G10<=75, 0, G10<=100, 250, G10<150, 350, G10<=200, 500)
This formula will return #N/A if G10 is larger than 200.
2) =IF(G12<750, 750, 0)
3) =IFS(G7<=2, 0, G7=3, 1, G7=4, 2, G7>=5, 2.5)*G9
HansVogelaar, I can't thank you enough! This worked like a charm. Thank you again!!!