Okay, what I am trying to do is have a deposit displayed on one worksheet depending on which company is selected. My problem is the only way I can think of to do the formula is multiple IF statements in the same cell, with the false outputs being “” and connecting them with &. The problem isn’t that I cant get the right premium to display, its just the cell loses its $ display because of the resulting falses that display “”. I cant just put in a general $ sign because it wont match what is on the rest of the sheet and it doesn’t always need to be there). I don’t know if that makes any sense, I will attempt to demonstrate it…

There are 3 companies (A, B, C). on sheet 1 the premium info is entered, sheets 2,3,4 calculate installment premiums based off the info on sheet 1. Sheet 5 displays the premium of the selected company (based partially on sheet 1 and either 2,3,4).

There is probably a really easy solution, I just cant seem to come up with one.

Thanks in advanced.