I am writing a user spreadsheet that requires a couple of drop down choices to prompt automatic cell...
(More)
I am writing a user spreadsheet that requires a couple of drop down choices to prompt automatic cell fills. I know how to create drop down lists. I cannot figure out how to get the drop down selected to prompt entry of the appropriate value into the appropriate cell or how to get the proper field to be presented when the appropriate choice is given. One of the dorp downs is a five choice drop down and the other is two. They both have cells or ranges that are appropriated by their selection. The five choice drop down has five fields to choose from to feed the appropriate cell the two choice drop down has two separate fields of data to present or input to.
using an excel sheet, assume that sum of some cells is 100.77 and i want to use this sum in other...
(More)
using an excel sheet, assume that sum of some cells is 100.77 and i want to use this sum in other cells but 100 in a cell and 0.77 in another cell, so what is the equation or what can i do to do it ??