Trying to write a IFS function looking at columns with IF formulas in them already

SGeorgie 

If you want to create an IFS formula in column P that considers the existing formulas in columns P and 'Correct Fee', you can use the IF function inside the IFS function. It seems like you want to check the value in P4 against the 'Correct Fee' and return specific values based on conditions.

Here is an example of how you might structure your formula:

=IFS( OR(ISBLANK(P4), P4 < [@[Correct Fee]]), "Too Low", P4 >= [@[Correct Fee]], "OK", TRUE, "Some other condition" )

This formula checks if P4 is blank or less than the value in 'Correct Fee'. If true, it returns "Too Low". If P4 is greater than or equal to 'Correct Fee', it returns "OK". You can add more conditions as needed.

Make sure to replace "Some other condition" with the logic you want to apply if none of the previous conditions are met.

Remember that IFS evaluates conditions in order, and the first condition that is true will be the result. Also, it stops evaluating conditions once it finds the first true condition. If your conditions are mutually exclusive, this approach should work for you.

NOTE: My knowledge of this topic is limited, but since no one has answered it for at least one day or more, I entered your question in various AI. The text and the steps are the result of various AI's put together. Maybe it will help you further in your project, if not please just ignore it.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.