In column A I have this formula:
= ARRAYFORMULA (IF(B1:B="Custom Rate","*enter rate", ARRAYFORMULA (IF(B1:B="High Rate",100,ARRAYFORMULA (IF(B1:B="Medium Rate",50,ARRAYFORMULA (IF(B1:B="Low Rate",20,""))))))))
And in column B I have a drop-down menu with the choices "Custom Rate, High Rate, Medium Rate, Low Rate". When a rate is chosen the corresponding value in the ARRAYFORMULA populates the cell in column A. I would like the value for "Custom Rate" to be editable.
Is there a way to have the value be equal to a wildcard character? Or is there any other way to allow me to edit the value?
Also, the "Custom Rate" value will always be a number between 1-100, if that helps.
Bookmarks