The following formula is attached to a Sampling template that I am trying do hard to understand. Can you explain the formula in smaller pieces please?

=IF(A11="","",1/IF(Input!F11="",IF(Input!G11<=Input!H11,1,Input!H11/Input!G11)*Input!C11,(Input!H11/Input!G11)*Input!C11*Input!F11))

Looking forward to your help, thank you.

Here is the goal: I want to allow people to enter information either increase amount in straight dollar amounts, or in percentage, and then display the new Annual salary based upon which one they enter I need the new annual salary amount to be in one column. The way i have chosen may not be the best way, but i was thiking if one cell has a number then do the first calculation, if one cell does not have a number then do the next calculation.

## Add new comment