# Complex nested formula help needed please

2697 5
cancel
Showing results for
Did you mean:
4 - Data Explorer

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

5 Replies 5
5 - Automation Enthusiast

Hi

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

10 - Mercury

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. :winking_face:

4 - Data Explorer

here is what I am trying to do;

if the column {reg fee} = 379, then i need the formula to look at the litres column and if the litres are less than 750 then X the litres by 0.09 and X 0.66. If the {reg fee} is over 750, then look at the litres column and X the litres by 0.66

To make it more complex, I then need to add the 379, but I think the easiest way to do this is via another formula in another cell.

10 - Mercury

For the record, this was what the OP was asking for…

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

Can anyone help solve this nested ifs statement?

If({Customer Name}contains “Ltd”,“Pty”,“P/L”,1)))

How would you write a working formula to make this work?