
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 07, 2020 12:12 PM
Could someone tell me what I’m doing wrong? For some reason this formula is able to input the money amount for job 1, 2, 3, and 5 but it shows up blank for job 4. What’s going on?
IF(
{Job Type} = ‘Job 1’,
“$ Amount”,
IF(
{Job Type} = ‘Job 2’,
“$$ Amount”,
IF(
{Job Type} = ‘Job 3’,
“$$$ Amount”,
IF(
{Job Type} = ‘Job 4’,
“$$$$ Amount”,
IF(
{Job Type} = ‘Job 5’,
“$$$$$ Amount”
)))))
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 07, 2020 12:31 PM
it’s been resolved :stuck_out_tongue:
