WebCell(Web SpreadSheet) by N Paul

Welcome to WebCell(Web SpreadSheet) by N Paul
V1.0.0

Loading...Please Wait

Add Functions using JS

Setting

You can Enter cell referance in here and change

Background color

font color

and even font size

Help
WebCell(Web SpreadSheet) by N Paul This project is originally made by me (N Paul) .It has a wide range of formulas that you can use to your calculation. You will find most common formulas already pre-defined here. Although I have not covered all formulas , for example I have not defined any 'range()' or ':' formula here(To be honest It would have been very complicated). However, you can also create your own functions / formulas or even variables,arrays or even object with JavaScript's code... Follow me on

Some pre-defined formulas:

abs(x): Return absolute value. e.g 'abs(-5)' return +5
acos(x): Returns the arccosine (in radians) of a number. 'x' is between -1 to +1
asin(x): Returns the arcsine (in radians) of a number.
atan(x): Returns The arctangent (in radians) of the given number.
atan2(x,y): Returns the angle in the plane (in radians) between the positive x-axis and the ray from (0,0) to the point (x,y).
cbrt(x): Returns cube root of the given number.
sin(x): Returns sine of the given number.
cos(x): Returns cosine of the given number.
tan(x): Returns tangent of the given number.
ceil(x): Returns smallest integer greater than or equal to the given number.
floor(x): Returns a number representing the largest integer less than or equal to the given number.
round(x): Returns the rounded value( to the nearest integer) of the given number.
rand(): Returns a floating-point, pseudo-random number between 0 (inclusive) and 1 (exclusive).
pow(x,y): Returns number representing the given base(x) taken to the power of the given exponent(y).
sqrt(x): Returns the square root of a given number.
log(x): Returns the natural logarithm (base e) of a number.
log10(x): Returns the base 10 logarithm of a number.
max(a,b,c..): Returns the largest of the given numbers.
min(a,b,c..): Returns the smallest of the given numbers.
mod(number, divisor): Returns the remainder after a number is divided by a divisor.
if(condition, ifTrue, ifFalse): If condition is true then return ifTrue else return ifFalse.
sum(a,b,c...): Returns the summation value of all inputted numbers
count(a,b,c...): Count all input parameter in number.
avg(a,b,c...): Returns average value of inputted numbers.
even(x): Returns true if given number(x) is even else return false
odd(x): Returns true if given number(x) is odd else return false
fact(x): Returns factorial of the given number
fibonacci(FibonacciNumberIndex): Returns Fibonacci number/value (according to the Fibonacci number series) of a given index value

You can add your own function via JavaScript code..
For example:(1) in [Add Function] just write 'var soda =50;'. and in cell whenever you write '=soda*2' it will return 100.
For example:(2) in [Add Function] write 'function areaOfRect(x,y) {return x*y}' . and in cell you can use this formula to calculate the area of a rectangle.
In this way you can define your own functions/formulas, variables, arrays, objects and almost anything...
Follow me on