Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.
Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.
Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.
Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.
Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.
Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.
Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.
Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.
Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.
Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.
Yes it could. You could use an IF function like this:
=IF( D10= 8742, .48,IF(D10=8810, .43, IF(D10=5542,3.87, IF(D10= 4, 4.1, IF( D10=5, 5.1, 6) ) ) ) )
That is a bit longwinded and it is easy to make a mistake. A better solution might be to use a VLOOKUP and put your list of search values in one column and the results you want in a second.