Hi Everyone
I'm a bit stuck
I want to create a calculation whereby I input length and width in two cells, which then automatically calculates area in another, then depending on that area (within a range) it generates another number.
For example
Length Cell C3 = 1000m
Width Cell C4 =300m
Cell E5 =C3*C4 (300,000)
Cell G5 =E5 - looks up range and if less than 25,000 = 100, between 25,000 and 50,000 = 200 etc.
Also then need to do the same but with letters
I input a letter in C7 and it looks that letter up in a range of 6 and depending on that letter it multiplies the result in G5 by 25%
Many thanks in advance
N
I'm a bit stuck
I want to create a calculation whereby I input length and width in two cells, which then automatically calculates area in another, then depending on that area (within a range) it generates another number.
For example
Length Cell C3 = 1000m
Width Cell C4 =300m
Cell E5 =C3*C4 (300,000)
Cell G5 =E5 - looks up range and if less than 25,000 = 100, between 25,000 and 50,000 = 200 etc.
25000 |
50000 |
100000 |
300000 |
500000 |
750000 |
1000000 |
Also then need to do the same but with letters
I input a letter in C7 and it looks that letter up in a range of 6 and depending on that letter it multiplies the result in G5 by 25%
Many thanks in advance
N