I am trying to automate some things in my finance class. I am doing a Differential Analysis and instead of typing text in manually (Manual Entry) I have been trying to use a formula (Automatic) but its not working out too well for me. If one of the Option values is higher or lower I need it to populate with Higher or Lower based on the values in a column.
I tried a few other things but the closest the formula I found was =IF(F28>H28, "Higher", "Lower") but it is not producing the correct results. Does anyone got a million-dollar answer?