Thursday 12 November 2015

Excel using IF condition with RIGHT function to get two decimal values if cell value >= 8

=IF(B2>=8,RIGHT(B2,2))

Example we have to fetch two decimal values if cell value is >= 8

By assuming B2 contains 8.32 , the output would be 32        

No comments:

Post a Comment