# Complex nested formula help needed please

#1

Hello,

I have a nested formula that works a treat, however I need to add on to it and I’m wondering if someone would have the expertise to help me.

Currently I have this;
IF(Litres<38,Litres0.66,IF(AND(Litres>=38,Litres<277),25,Litres0.09))

I have a whole other column called {reg fee} which I need the above IF formula to only be run if {reg fee} is NULL, and then IF the {Reg fee} = 379, and Litres is <750, then add 379 + Litres *.66, or if {reg fee} = 379, and Litres is >750, then add 379 + Litres *.9 *.66

Hope someone can help me make sense of this! Any help greatly appreciated

#2

Hi

Maybe if you provide a screenshot of what you are trying to do it would be easier to help you.

#3

Small tip: you can use multiple fields (and hide them later) in combination with single / simpler formulas. Then use a final field to pick the outcome you need (or make sure only one field has an actual result and add all of them up).

This way you can also easily see what’s going on / wrong by looking at the separate fields / formulas.

#4

``IF(AND({REG FEE} = 379, LITRES > 750), (LITRES * .09) + 379, 0)``