I'm trying to create a formula currency field that has both numeric and text fields. Is this possible? This is my formula and the error I'm getting:
If([Total Expenses]+[Total Activity Budget]>[Total Total Contract Amount], [Total Un-Contracted Expenses]+[Total Total Contract Amount], [Total Un-Contracted Expenses],
[Expense Code]="Fringe", "Salaries", "Indirect", [Total Budget])
------------------------------
Bethany Hudson
------------------------------
Question
Multiple Conditions IF Formula
This topic has been closed for replies.
+24It's not possible to do that with a formula numeric field as the result needs to be numeric.
The closest you can come is to have a formula text field and then convert the numeric result to be text even though it will look like a number. But for example you would not be able to run a total on the column. The messy part about that is getting the formatting correct to show the currency value with a $ sign and decimals. If you want to go that route we can probably help you with a formula.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
The closest you can come is to have a formula text field and then convert the numeric result to be text even though it will look like a number. But for example you would not be able to run a total on the column. The messy part about that is getting the formatting correct to show the currency value with a $ sign and decimals. If you want to go that route we can probably help you with a formula.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.