Hey Gang,
Would someone do me a solid and give me a hand with this?
I'm trying to get as much of a sheet to fill out as possible when pasting a value to speed things up in my team. One thing I can't get to work is the below in cell B25.
=IF(LEFT(C25)="S","Value1","Value2")
What this formula currently does is look if the first letter in an adjacent cell, if the first letter is S the value in B25 will change to "Value1" which is great. Problem is I want a third option.
1. If C25 cell value begins with S = Value1
2. If C25 does not begin with S = Value2
3. If C25 is blank = B25 should also be blank.
Is there a way I can keep the cell blank without the use of conditional formatting within my formula until a user has inputted a value?
Thanks everyone
Would someone do me a solid and give me a hand with this?
I'm trying to get as much of a sheet to fill out as possible when pasting a value to speed things up in my team. One thing I can't get to work is the below in cell B25.
=IF(LEFT(C25)="S","Value1","Value2")
What this formula currently does is look if the first letter in an adjacent cell, if the first letter is S the value in B25 will change to "Value1" which is great. Problem is I want a third option.
1. If C25 cell value begins with S = Value1
2. If C25 does not begin with S = Value2
3. If C25 is blank = B25 should also be blank.
Is there a way I can keep the cell blank without the use of conditional formatting within my formula until a user has inputted a value?
Thanks everyone