I have a case to handle remainder is rounded number or not? for example, if case1: m=3, QR=5 QR/MOQ,5/3=1.6667… remainder is not rounded value case2: QR=6,m=3 6/3=2, the remainder have rounded what is the logic to do this @THIRU_NANI @Palaniyappan @Gangadhar_Athili

Hi! Yeah, Got it in If Condition Do Like this InputText.Contains(".") Then part-> Else Part-> Regards, NaNi

How to check the remainder has a rounded value or not, can any one help me out this

THIRU_NANI (NaNi) July 1, 2022, 10:54am 2

Hey!

Check this out

Regards,
NaNi

Topic		Replies	Views
How to identify and classify the round value and not round value in Excel or DataTable Studio studio , question	2	342	March 13, 2023
How to round of a decimal to the nearest value? Help	5	8893	October 29, 2018
Calculater robot Help uiautomation , studio , question	11	1302	December 13, 2019
Rounding cell values Studio studio , question , activities_panel	2	757	April 23, 2022
Check if a number has a decimal place/is a whole number Help	5	13623	May 6, 2019