Previous Topic Next Topic

Cell Referencing & Calculating

Closed
Tim - 10 Dec 2009 à 21:56
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 11 Dec 2009 à 05:43
Hello,

I am trying the fiure out how to get a cell to calculate base on the result of another cell.

Let's say In A1 I have Changing Text based on a drop down menu (Pizza, Burger, Chips, misc). I want C1 to display what is in B1 based on what is being displayed in A1.

Any help would be great.

A1 B1 C1
Pizza 60 If A1 = Pizza then C1 = A1

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
11 Dec 2009 à 05:43
do you mean to say that if A1 is burgher C1 also should be burgher whatever B1 is
if A1 is chips C1 should be chips whatever B1 is

in that case simply type in C1 this formula
=A1

If assumption is not correct explain clearly with examples

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses