ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW I WRITE 12=10 OR 16=20 in excel (https://www.excelbanter.com/excel-worksheet-functions/254169-how-i-write-12%3D10-16%3D20-excel.html)

Rana

HOW I WRITE 12=10 OR 16=20 in excel
 
if A1=12531 how i wrote in 12530 IN B2 coloum

Mike H

HOW I WRITE 12=10 OR 16=20 in excel
 
=A1-1
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"RANA" wrote:

if A1=12531 how i wrote in 12530 IN B2 coloum


Teethless mama

HOW I WRITE 12=10 OR 16=20 in excel
 
=ROUND(A1,-1)


"RANA" wrote:

if A1=12531 how i wrote in 12530 IN B2 coloum



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com