SJSB
New Member
- Joined
- Apr 16, 2021
- Messages
- 3
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
I am trying to create a spreadsheet to calculate pricing based on variables for different categories.
I would like the drop down options to be as in row 2 - either a number or a multiple choice.
Depending on what is selected, it would have a different value - eg only 1 property would be 100 but two, would be 170 (100+70 and then 3 properties would be 240).
Can someone please point me in the direction of where to find how to do this?
I don't even know what terms to google!
Huge thanks,
Sasha.
I would like the drop down options to be as in row 2 - either a number or a multiple choice.
Depending on what is selected, it would have a different value - eg only 1 property would be 100 but two, would be 170 (100+70 and then 3 properties would be 240).
Can someone please point me in the direction of where to find how to do this?
I don't even know what terms to google!
Huge thanks,
Sasha.