Forum Discussion
Is it possible for a formula to change depending on the choice from a drop down list
Good Afternoon, Is it possible for a formula to change depending on a drop down list choice? I am trying to create a spreadsheet which removes a lot of admin work. In this example I am trying ...
You want to use an IF function. try:
=IF(A1="KG", [gross weight]*[KG cost], [Unit price]) / [parts per blow]
so basically the IF statement will check the [condition] and then return either of the following parts based on if the result is true or false. In your case you have [part per blow] in both cases so I pulled that out of the IF function. if [KG cost] and [Unit price] are both in the same call/column (i.e. if it is KG then that cell contains KG cost and if it is Blank then it contains Unit price) then the formula could be
=IF(A1="KG", [gross weight], 1) * [KG cost & Unit price cell] / [parts per blow]
if you give a sample sheet it would be easier to be more specific.
=IF(A1="KG", [gross weight]*[KG cost], [Unit price]) / [parts per blow]
so basically the IF statement will check the [condition] and then return either of the following parts based on if the result is true or false. In your case you have [part per blow] in both cases so I pulled that out of the IF function. if [KG cost] and [Unit price] are both in the same call/column (i.e. if it is KG then that cell contains KG cost and if it is Blank then it contains Unit price) then the formula could be
=IF(A1="KG", [gross weight], 1) * [KG cost & Unit price cell] / [parts per blow]
if you give a sample sheet it would be easier to be more specific.
Hi,
Thank you for your response,
I have attached a sample sheet below.
With the IF function, how do you write it as IF Blank and then IF Coil?
https://1drv.ms/x/s!AqQ4oTh829BSvFKs-FNmp7nqpIaI?e=YMjfHn
Cheers
Thank you for your response,
I have attached a sample sheet below.
With the IF function, how do you write it as IF Blank and then IF Coil?
https://1drv.ms/x/s!AqQ4oTh829BSvFKs-FNmp7nqpIaI?e=YMjfHn
Cheers
