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”

)))))