IFS

Question

Hi,

Wondering if there is a way to make =IFS read only the decimal numbers in a sequence, rather than rework the number. E.G I have 14.58 but only want to IFS to read .58 and not the 14 ?

Reason for this is - I want to run IFS with roundup to automatically increases the decimal place based on criteria. Criteria = if decimal place >.5 round up to .99 if <.5 round up to .49 etc. 

Thanks.

Answer 1

If you are only checking two conditions you don't need IFS.  You can just use IF

if((A2-Trunc(A2))>.5,result, other result)

This would check >.5 and <=.5

if you want three conditions, then you could use IFS

IFS((A2-Trunc(A2))>.5,Result,(A2-Trunc(A2))=.5,Result,(A2-Trunc(A2))<.5,Result)

although doing an exact equality check on a floating point number might not give you the results you expect.

--

Regards,

Tom Ogilvy

Answer 2

Is it you are looking for. Formula at B2 is    =IF(MOD(A1,1)<0.5,INT(A1)+0.49,INT(A1)+0.99)   copy it down.

Answer 3

You can put like below

=IFS(A2>mod(B2,1), Result, A3>mod....

Where B2 has the decimal number