ellinator Posted June 7, 2006 Share Posted June 7, 2006 I don't know if this is even possible, but I would like to use a formula that could do the following.If (cell#) is greater than (a number in another cell) multiply by (a number in another cell)If it is greater than (a number in another cell) or less than (a number in another cell) multiply by (a number in another cell) (repeat the bold area 2 more times) Thanks Link to comment Share on other sites More sharing options...
phkninja Posted June 7, 2006 Share Posted June 7, 2006 From what i can make out you are looking forif A1 > B1 then AA1=A1*C1If A1 >A2 and A1 <B2 AA2=A1*C2.......where AA1 and AA2 are used as tempoary hold cells(As i dont think A1=A1*C1 works in excel)Is this right Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now