Cell Referencing & Calculating

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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