Daryl has attended:
Excel Advanced course
If cell contians text
I have a spreadsheet where I wantr to perform the following
I want to populate cell D80 with the following
Cell C80 I enter text - Yes or No
If I enter Yes I want D80 to = the value (eg
RE: If cell contians text
Hi Daryl
Thank you for your question.
Please see the attached file for an example of how this would work - it uses an IF function to enter the result.
Amanda