Forum Discussion
IF Statement Problem
=IF(D23,0,D17-(D17*C24)IF(D22,0,D17-(D17*C24)IF(D21,0,D17-(D17*C24)))) Hello everybody new boy just joined, I am having problems with this statement could anybody help out, I have done...
Hi.
Thanks for the solution but it does not quite work, This is data for options on ventilation programme and capacity, D21:D23 are 0 if the option to use if the types are not used, If they are "0" then the D17 is the number of people reduced by 30% so the data in D17 is formatted at percentage, hope that makes sense. The end part of the formula works on its own!
Thank you for the time.
Lee
| Cross Ventilation | 0 | 0 | |
| Single Sided Ventilation | 0 | 0 | |
| Air Handling Ventilation | 0 | 0 | |
| Absence of Verifiable Ventilation Reduce | 30% | 0 | |
| Ventilation Capacity |
The layout doesn't match your formula. It also lacks column and row headers.
And if every value is 0 then subtracting and multiplying does not change anything.
Please provide a workbook with a meaningful explanation.
