Forum Discussion
onpointsupplies
Jan 05, 2023Copper Contributor
Tab formula
how can I have a tab in which I have a drop down tab with two options (a) & (b) that by the choice that is made another tab with a $ value gets calculated to another tab based on which is selected. example if I selected (a) and the profit is $100 and I select two more (a) with each being $35 the tab will say $170
- LorenzoSilver Contributor
onpointsupplies You're welcome...
- onpointsuppliesCopper Contributor
any ideas would really help ??? onpointsupplies
- LorenzoSilver Contributor
I suspect nobody really understand your question, probably due to the exessive usage of the word "tab" that makes things quite confusing if I may
#1 To clarify things, could you post a picture that illustrates what you have + a couple of examples of what you expect?
#2 Cf. Welcome to your Excel discussion space!, what version of Excel do you run & on which OS/Platform (Windows, MacOs, Web...)?
- onpointsuppliesCopper ContributorI have Excell for Mac and its version 16.88