Quote:
Originally Posted by Vonar
I want to set up an assumption that Threshold =10% so that I can just use the name "threshold" in an IF formula.
How do I do this??
Thank you anyone for your help!
|
------------------------------------------------------
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)