Surds operations in Excel spreadsheets.

[Prashantakerkar]

I would like to know whether Surds operations work in Excel spreadsheets?

Example :
Cell E1= 2√3
Cell E2=4√3

Will Cell E3=Sum(E1,E2) = 6√3?

And other Surds operations viz product, division etc?

Will the Data type for inputing Surds values in Cells should be Decimal numbers?

Thanks & Regards,
Prashant S Akerkar

 

[andre_luis]

Excel spreadsheets perform the same operation as any calculator, but do not handle surds values symbolically as you would expect, but mathematically, which means that √3 is replaced by its numerical value 1.732050... with a reasonable resolution with a which you won't worry about.