ExcelBanter - I need a conditional formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - I need a conditional formula (https://www.excelbanter.com/excel-programming/358635-i-need-conditional-formula.html)

InspectorPaul

I need a conditional formula

If the total of a cell is any decimal part more than the whole number (
Example 1.01 raise it to the next whole number 2) and then multiply by a
known number.

Answer 1.01 now becomes 2 X 50

Jim Thomlinson

I need a conditional formula

Assume the number is in Cell A1

=roundup(A1, 0)*50

--
HTH...

Jim Thomlinson

"InspectorPaul" wrote:

If the total of a cell is any decimal part more than the whole number (
Example 1.01 raise it to the next whole number 2) and then multiply by a
known number.

Answer 1.01 now becomes 2 X 50

All times are GMT +1. The time now is 09:58 PM.