IF Function query

[Roshan_K]

Hi,

I just want to know with the help of IF function. can I add one specific character in the beginning of any cell in Excel.

Could you please help me with the example, so that it will help me to understand.

Thanks 

[#2]

@Roshan_K 

If you'd like to take cell value, modify it and return the new value into the same cell, that's not possible with the formulas, only with VBA programming.

If return modified value into another cell, which formula to use depends on logic of transformation. For example, to return into B1 modified value from A1

=IF(A1="abc","1-" & A1, A1)

[#3]

Thanks Sergei for your quick response.

[#4]

Hi Sergei,
I have one more question regarding to below query;
Available Stock, Min stock, Max Stock
5000, 2000, 6000

I want to add if formula which can compare my available stock with min stock and max stock and show me the result as short or excess.

Could you please help me to get the result.

Thanks and Regards,

Roshan

[#5]

@Roshan_K 

This might have been better as a fresh discussion.

= IF( available>max, "Excess", IF( available<min, "Short", "" ) )