Formula not working on a cell which has an other formula

[ahmad08]

Hi,

I am working on a sheet having 3 columns as below.

A B C
[TABLE="width: 111"]
<colgroup><col></colgroup><tbody>[TR]
[TD]AED 112,980.00[/TD]
[/TR]
[TR]
[TD]AED 129,720.00[/TD]
[/TR]
[TR]
[TD]AED 419,456.00[/TD]
[/TR]
[TR]
[TD]AED 373,417.50[/TD]
[/TR]
</tbody>[/TABLE]

In column B I am using formula =RIGHT(A1,LEN(A1)-3)
In column C I am using formula =MAX(B1:B96)

Formula in column C is not working but when I write value in column B manually it starts working.

Below is link of file.

Formula not working on a cell having other formula.xlsx - Google Drive

 

[Norie]

Try changing the formula in B to this.

=VALUE(RIGHT(A1,LEN(A1)-3))

 

[ahmad08]

Hi Norie,

Thanks a lot. It worked.