Cell Referencing & Calculating

Closed
Tim - Dec 10, 2009 at 09:56 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 11, 2009 at 05:43 AM
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 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Dec 11, 2009 at 05:43 AM
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
0