Forum Discussion
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 101-149 enter $350, if mileage is 150-200 enter $500.
Second formula help needed:
If there is an amount of =<$749 on a specific cell (G12 in this case), populate $750, or if =>$750 populate $0
Third formula help:
If there is a specific number in a cell (G7 in this case) of =<2 populate $0, if =3 populate $1 x #of cabinets (in this case G9 to get number of cabinets), if =4 populate $2 x #of cabinets (in this case G9 to get number of cabinets), if =5 or elevator populate $2.50 x #of cabinets (in this case G9 to get number of cabinets).
Thank you much!
Sandra S
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
2 Replies
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!!!
