I am trying to create a pricing spreadsheet that when opened will first prompt the user to input the # of locations for that specific customer. Once entered the spreadsheet is then automatically updated to provide a row corresponding with the # of locations specified. (i.e. if the user inputs 6 locations, 6 rows would appear under the location portion of the spreadsheet)
I have seen these before but have no idea what they are called. Can someone help me with the name and where I might be able to find an example of how to create them.
Additionally, I have noticed that when creating =if(x=y,z) statements that I can only enter 8 total conditionals. If I want to expand this, is there a way to do this?
Thanks,
Brian
I have seen these before but have no idea what they are called. Can someone help me with the name and where I might be able to find an example of how to create them.
Additionally, I have noticed that when creating =if(x=y,z) statements that I can only enter 8 total conditionals. If I want to expand this, is there a way to do this?
Thanks,
Brian