Solved If/and formulas Excel help

November 6, 2016 at 08:25:44
Specs: Windows 7
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


See More: If/and formulas Excel help

Report •

#1
November 6, 2016 at 09:34:46
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 before you enter a value in M3?

A bit more info and possibly an example would be helpful.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
November 7, 2016 at 05:37:40
✔ Best Answer
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.


Report •
Related Solutions


Ask Question