• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Explain the FORMULA please

D

debarajdutta

New Member
Can someone please explain the following 2 formulas in simple terms:


=IF(ISNUMBER($W9),1+(1-$W9/$AF$7),"")


=IF(ISNUMBER($V9),$V9/$AE$7,"")


Thank you.
 
Hi Mr. Dutta,


Welcome to the forum..


Yes.. If W9 cell is filled with any Number.. only then it will perform the calculation. (1+(1-$W9/$AF$7)).. otherwise.. it will not perform the calculation, and will give you blank answer..


For more detail please visit..

http://chandoo.org/excel-formulas/if.shtml

http://chandoo.org/excel-formulas/isnumber.shtml


Regards,

Deb.
 
The IF function consists of 3 'arguments' or parts:

=IF(CONDITION,VALUE_IF_TRUE,VALUE_IF_FALSE)

NOTE: Like with all Function, the arguments are separated with a comma (,).


=IF(ISNUMBER($W9),1+(1-$W9/$AF$7),"")

If the value/content of Cell W9 is a number the condition would be TRUE so it will proceed to the Value_If_True argument: 1+(1-$W9/$AF$7). If the value of Cell W9 is not a number the condition would be FALSE and it will proceed to the Value_If_False argument: "" (this will simply return no value (blank cell)


=IF(ISNUMBER($V9),$V9/$AE$7,"")

If the value/content of Cell V9 is a number the condition would be TRUE so it will proceed to the Value_If_True argument: $V9/$AE$7. If the value of Cell v9 is not a number, the condition would be FALSE thus proceeding to the Value_If_False argument: "" (this will simply return no value (blank cell)
 
You must log in or register to reply here.
Back
Top