Trying to understand the formula

3 posts / 0 new
Last post
Trying to understand the formula

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))

Trying to understand the formula

Looking forward to your help, thank you.

Here is the goal:  I want to

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