1. I've different values in cells I2 to I9
2. My 'D' column cells require 'if' statements
And using this table:
1 < x < 5 in 'C' cells, 'D' cell in same row will be = C5*I2:
Use values:
I2 if 1 < x < 5,
I3 if 5 < x < 10
I4 if 10 < x < 15
etc.
1. I've different values in cells I2 to I9
2. My 'D' column cells require 'if' statements
And using this table:
1 < x < 5 in 'C' cells, 'D' cell in same row will be = C5*I2:
Use values:
I2 if 1 < x < 5,
I3 if 5 < x < 10
I4 if 10 < x < 15
etc.
Last edited by puritydl; 10-17-2011 at 03:56 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks