Brandensa14
New Member
- Joined
- Feb 3, 2025
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
So below I have where I'm at, but can't figure out where to go from here. Right now, this formula is returning a value (equation) when a cell in table "Division" DOES NOT contain the letters "RBLD". I also need it to return a different value (equation) if DOES contain the letters "RBLD". So in words I want the equation to do this: If does contain "RBLD" then return [equation] OR if does not contain "RBLD" then return [different equation]. The equation for the DOES NOT is 10% of a column [@Collected] minus value from another column [@Subs]. The equation for the DOES contain "RBLD" will be 5% of a column [@Division] minus another column [@Subs].
FYI, I have the IFERROR in the beginning so the cell is blank when transferring over from another sheet and different names cause an error.
Let me know if you need additional information. Thank you!
=IFERROR(IF(ISERROR(SEARCH("RBLD",[@Division])),[@Collected]*0.1-[@Subs],""),"")
FYI, I have the IFERROR in the beginning so the cell is blank when transferring over from another sheet and different names cause an error.
Let me know if you need additional information. Thank you!
=IFERROR(IF(ISERROR(SEARCH("RBLD",[@Division])),[@Collected]*0.1-[@Subs],""),"")