Latest Posts

IF function in Excel

IF function in Excel

We shall learn here one of the most used functions in Excel and it is IF function. IF function Syntax in Excel IF(logical_test, , ) Example: IF(B3>100,"Over the Budget"," Within Budget")The ...

READ MORE +

FIND function in Excel

FIND function in Excel

FIND function Syntax in Excel FIND( substring, string, ) Example: FIND ("ual", "Annual Report 3 Dec, 2013",1)In simple language the above example tells Excel to do: Search sub-string "ual" (if ...

READ MORE +

LEN function in Excel

LEN function in Excel

LEN function Syntax in Excel LEN (text) Example: LEN ("Annual Report 3 Dec, 2013")In simple language the above example tells Excel to do: Return the number of characters of “Annual Report 3 ...

READ MORE +

RIGHT function in Excel

RIGHT function in Excel

RIGHT function Syntax in Excel RIGHT (text, ) Example: RIGHT ("Annual Report 3 Dec, 2013",3)In simple language the above example tells Excel to do: Return the last 3 characters of "Annual ...

READ MORE +