RE: IF function - Is it possible to return current cell value when using IF function

marty whiteman

Simple example: cell value could be equal any number between 0-10

If(cell value@row = 15, 25, [current cell value])

Darren Mullen

@marty whiteman I'm not sure I understand what you are asking...

If you mean a formula and a cell value in the same cell, you can't have a formula and a cell value at the same time in a cell, if that is what you are talking about.

If by current cell value, you mean the value from another cell, then you can do that.

marty whiteman

@Darren Mullen - thank you for your response. Sorry for not being more clear. I was thinking in terms of a formula within the cell that I want to change the value in. Would you mind posting a formula example?

Darren Mullen

@marty whiteman What's wrong with the formula that you posted.... is it not doing what you want?

marty whiteman

@Darren Mullen - Short Answer: No

Let me tighten up that example using 3 columns

Column 1 - Done (checkbox - checkmark) value = 0

Column 2 - Recurring (checkbox - star) value =1

Column 3 - Status (symbol -"RYGGray") value="Red"

=IF(And(Done@row=1,Recurring@row=1,"Gray")

If the conditions are met, a gray symbol will appear in Status, however if is not met, then the column value of "Red" is replaced with "".

Is there a way to use the IF function and return the original value of the cell, which in this case is "Red"?