Hi, I am trying to come up with a formula to do the following:
- I have two status columns, and a numbers column. The first stats column tells me if a client is being billed directly or through us. The second one to tell me if there is a markup, and the numbers column has the invoiced amount.
- I am able to use the IF statement to either calculate and show the final number with or without markup if I change the second status column to yes or no. HOWEVER, I would only like it to show a result IF I change the first status column to “billed through us.” If that is not the case, I don’t want it to show anything. Is there a way to do this with a formula?
Thank you in advance.