0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Can Excel accommodate the following scenario in a formula If D10 equals 8742 then .48 if D10 equals 8810 then .43 if D10 equals 5542 then 3.87 and so forth for 6 different values?
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.
What are some of the meanings of the character string D10?
There is no such thing as a character string D10. This is an invalid question and doesn't leave much to answer for this question. Technically speaking a character string D10 would return just the phrase D10.
65?
65 - T15, D10
68?
68 - T16, D10
Canon powershot d10 discontinued?
Yes
Which of the selections below denotes an excel formula to add up the data valued within cells D2 through D10?
=sum(d2:d10)
How much does a Caterpillat D10 bulldozer weigh?
A CAT D10 fully equipped, weights about 125,000 lbs. (57.2 Tons)
What is better to use in adding cells that are not aligned in any row or column?
There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.There are various ways you could do it, all of which just involve listing the cells. For example, each of these will do the same thing:=A3+C4+D10+F34+K90+V24=SUM(A3,C4,D10,F34,K90,V24)=SUBTOTAL(9,A3,C4,D10,F34,K90,V24)The 9 in the SUBTOTAL function tells Excel to add the listed cells.
What is the fuel consumption of a D10 dozer?
The fuel consumption of a D10 dozer is dependent upon the work load. The dozer will consume approximately 4 gallons per hour under a normal workload.
Can Emily Osment operate a Caterpillar D10 bulldozer?
She does not know how to operate a bulldozer.
What is the next number in the sequence M23 N23 D9 D10 V30?
X30
What is the LCM of 6 an d10?
Least Common Multiple (LCM) for 6 10 is 30.
