With my sheet, I need it so that if the job is any type of "Repair" then it minuses 1000 from the business profit but if it's anything else it doesn't minus the 1000 from the business profit. I have spent a bit trying to work this out however I am completely unsure on how to do this.

The current formula I use is:

``````=IF(J4=TRUE,SUM(F4-I4)-1000,"")
``````

which makes sure it won't appear until the paid is done and also removes the \$1000 from the price however when I choose something like "Tow" or "Lock Pick" it will still remove the \$1000.

A few things I have tried are

``````=IFS(QUERY(E4, "Where E contains 'Repair'")<>"",F4-I4-1000,E4="Tow",F4-I4)
``````

I am rather new to all these sheets so formatting will be wrong which is why I believe the above didn't work.

``````=IF(E6=INDEX(Key!\$D\$1:\$D\$3,MATCH(E6,Key!\$D\$1:\$D\$3,0),0),F6-I6-1000,F6-I6)
``````

I have another page with "Key" on it which is used to grab the names and prices for everything and matching it. I thought that with the above formula that if I can get it to match the repair types then it would output the -1000 for that else it wouldn't minus anything from it. I am not sure if the formatting is wrong however it seemed fine to me.

Photo for reference, I can explain anything needed.

• can you share a copy of your sheet? Jul 27, 2019 at 10:49

``````=ARRAYFORMULA(IF(J4:J=TRUE,