View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tarheelrooster tarheelrooster is offline
external usenet poster
 
Posts: 5
Default Function or formula ?

I have a cell D17 that is formatted tog give an answer when A4 is divided by
N4. I want to divide the answer of D17 by 1.73 when I put a 3 in cell P4. I
would like the 3 to stay in P4. I will from time to time put a 1 in P4 but I
do not want the 1 to change anything.