Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
I have a calculation sheet which I'm doing at work but I'm having trouble figuring out how to make it work. The sheet is used to calculate the time taken to complete a welding operation and relies on two values which are inputted by the user (in this case arm length in cell G5 and number of joints in G6).
The condition I'm trying to compute is along the lines of the following:
If G5<=12 and if G6=0 then use a known value in T21
If G5<=12 and if G6=1 then use a known value in T21
If 12>G5<18 and G6=2 then use a known value in U22
If 18>G5<24 and G6=2 then use a known value in U23
If 18>G5<24 and G6=3 then use a known value in V23
I can cope with single if functions but this dual if has got me stumped. I can email the actual sheet if it would help. Any ideas?
Cheers
IF(AND(G5<=12,G6=0),T21)
etc...
This works in openoffice. Excel should be the same but change semicolons to commas. 999 is the result if the tests are false.
=IF(AND(G6=3;G5>18;G5<24);V23;999)
Cheers allthepies!