One small correction to my formula
(A4/N4)/if(P4=3,3,1)
should be
(A4/N4)/if(P4=3,1.73,1)

--
Wag more, bark less


"Brad" wrote:

If P4 will only have the values of 1 or 3

then simply change the formula of (A4/N4) to (A4/N4)/P4. When you divide
anything by one - you still get the original number - otherwise you will get
the number divided by three.

However if P4 can be blank - an easy fix would be to change the revised
equation above to (A4/N4)/if(P4=3,3,1)

--
Wag more, bark less


"tarheelrooster" wrote:

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.