Excel TRIM Formula
TRIM Formula
This formula is used to remove unnecessary space in a cell or Text.
Example
=TRIM(A1)
Cell A1 has unnecessary space between Ram__Kumar __Gupta, so it removes unnecessary space and give RESULT = Ram_Kumar_Gupta.
IF Formula in Excel
IF Formula IF function is Logical function which is used to perform a logical test. Example =IF(A1>33,”P”,”F”) Result - P The value of Cell A1 is 50 which is greater than 33. The logical test is, IF the value is greater than 33 then result would be P else the result would be F. So the result is P.
Comments
Post a Comment