I have a column that will split two other columns' value in half if it is less than 1. So if m3<1, then k3/2 and l3/2. How would I write this and which column would I put this in. However, I need to be able to enter in k3 and l3 manually before I put in the value of m3. I thought I had excel formulas down but apparently not!

message edited by kstamper

I need to be able to enter in k3 and l3 manually before I put in the value of m3.How can K3 and I3 be half

beforeyou enter a value in M3?A bit more info and possibly an example would be helpful.

MIKE

message edited by mmcconaghy

I may be as confused as Mike, but why can't you just choose any column, other than I, K and M, enter this formula... =IF(M3="","",IF(M3<1,K3/2,K3))

Let's say you choose J3 for the formula. J3 will remain blank when M3 is empty. When M3 contains a value, J3 will display K3/2 if M3<1 or K3 if not.

Repeat for I3 in any other column.

Is that what you are looking for?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History