RattlingCarp3048
Board Regular
- Joined
- Jan 12, 2022
- Messages
- 166
- Office Version
- 365
- Platform
- Windows
HELP... i need to make a formula that is a bit more complex than I am used to. if there is a much simpler way than my initial approach i am open to alternative methods.
Columns F, H, and N each contain their own formula. They either result in a number or a "-" as a result of an error.
I need Column P to = F+H+N.
If Column B = "IHC" then calculate F+(H*3)+N instead.
If any one or combination of F, H, or N = "-" calculate the others instead. For instance
If B = IHC then calculate F+H*3+N otherwise calculate base
If B = IHC then calculate F+H*3+N
If F = - then calculate H+N
If H = - then calculate F+N
If N = - then calculate F+H
If F+H = - then calculate N
If F+N = - then calculate H
If H+N= - then calculate F
If B = IHC then calculate H+N
If B = IHC then calculate H+N etc...
Columns F, H, and N each contain their own formula. They either result in a number or a "-" as a result of an error.
I need Column P to = F+H+N.
If Column B = "IHC" then calculate F+(H*3)+N instead.
If any one or combination of F, H, or N = "-" calculate the others instead. For instance
If B = IHC then calculate F+H*3+N otherwise calculate base
If B = IHC then calculate F+H*3+N
If F = - then calculate H+N
If H = - then calculate F+N
If N = - then calculate F+H
If F+H = - then calculate N
If F+N = - then calculate H
If H+N= - then calculate F
If B = IHC then calculate H+N
If B = IHC then calculate H+N etc...