Conditioning formula to convert "x" into another cells value

blondelakelover Posts 1 Registration date Wednesday January 27, 2016 Status Member Last seen January 27, 2016 - Jan 27, 2016 at 12:24 PM
 Blocked Profile - Jan 27, 2016 at 05:05 PM
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 response

Blocked Profile
Jan 27, 2016 at 05:05 PM
OK, the syntax for if is as follows:



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!