I think the best way to go about explaining this is to use an example:

If A1="LTV" then I would like the value in A2 to be a formatted as a percentage, If A1="DSCR" then I want the value in A2 to be a general number with two decimal values.

Thanks!