Originally Posted by Mazzaropi

------------------------------------------------------
Dear Vonar, Good Morning.

To do this you must to NAME a cell and call it THRESHOLD.

1) Select the cell that will contain a threshold value. eg: A1
2) Type 10%
3) With this cell selected go to MENU -- INSERT -- NAME -- DEFINE
4) Type Thresold on the name field
....Now you can see below that appears on "Refers to": =Plan1!$A$1
5) Click OK

Now you have a named cell called THRESHOLD

You can use it in a IF statement.
eg.:
a) =IF(H410,H4*threshold,H4)
....Suppose you have this formula on D4.
....Suppose H4 = 20
......Then D4 has (H4*threshold -- 20*threshold -- 20*10% -- 2)