Software

Ask something
Question Locked

problem in excel

0 helpful
2 replies

by manraj12670

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

sir,
i have formula
contents in (cell a1+ cell b1)*3% = result
But result will not be in intiger.
if the result is 1.1 to 1.9 then it should be =2 (rounded)

2 replies

by bizzo

=CEILING((A1+B1)*3%,1)

This will round up to the nearest integer.

This discussion is closed to new replies.