gymwrecker
Active Member
- Joined
- Apr 24, 2002
- Messages
- 390
- Office Version
- 365
- Platform
- Windows
- MacOS
Is there a way to use multiple formulas for just one cell without damaging the others?
Thanks!
Thanks!
SR NO | DESCRIPTION | Rate | Quantity | AMOUNT |
1 | ||||
2 | Chicken Spicy Wings(500Gm) | 210 | 5 | 1050 |
3 | Chicken Nuggets (1000Gm) | 315 | 5 | 1575 |
4 | Chicken Nuggets (1000Gm) | 315 | 5 | 1575 |
FALSE | 0 | |||
FALSE | 0 | |||
FALSE | 0 | |||
FALSE | 0 | |||
FALSE | 0 | |||
FALSE | 0 | |||
FALSE | 0 | |||
FALSE | 0 | |||
FALSE | 0 | |||
FALSE | 0 | |||
FALSE | 0 |
=IF(A2="","",YourExistingFormulaHere)
Multiple CONDITIONS, yes. Multiple formulas, no.
For instance:
=IF(OR(A1>0,A1<25),"Yes","No")
will return Yes if A1 is between zero and 25, and No if it is zero or less than zero, or greater than 25.
Book1 | |||
---|---|---|---|
D | |||
1 | 10/25/2018 | ||
2 | |||
3 | |||
4 | |||
5 | |||
6 | 10/4/2018 | ||
Sheet310 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1 | =IF(D6=0,"",D6+21) |