Conditioning formula to convert "x" into another cells value [Closed]

Report
Posts
1
Registration date
Wednesday January 27, 2016
Status
Member
Last seen
January 27, 2016
-
 Blocked Profile -
good morning,

I have a spreadsheet I am trying to create for a chili cookoff, I am trying to find a way to type an "x"(or any text) in a box showing they signed up for a certain portion of the contest, and the formula automatically taking the value from another cell and inserting it instead of the x.

for example
A1- Chili B1- ribs
A2- $15 B2- $10
A3- x B3-

I would like A3 to automatically convert into A2 if anything is typed into the field and B3 to mimic B2 only if text is typed into the field.

Thank you so much for assisting me in this conundrum!

1 reply


OK, the syntax for if is as follows:

=IF(LOGIC_TEST,true,false)

=If(a3<>"",a2,"")

The above would populate the cell that has this formula with A2, as long as something is in A3. It shows nothing if there is nothing.
Give that a shot and see if it is acting how you would expect. Then use that example and continue to cascade the solution!


I have said it once, I will say it again. IT!