LinkBack URL
About LinkBacks
i have a excel file and i want to reduce all cells to zero which are having values less than 80
please help!!!
condition check
i have a excel file and i want to reduce all cells to zero which are having values less than 80
please help!!!
=if(a1<80,0,a1)
thanks buddy for reply, but you've written it for a single cell i want that it should do the same for entire sheet
i.e. if a particular cell's value is greater than 80 then it can be kept constant or otherwise 0
sheet is too big 501X256
goto conditional format and make the cells italic(make sure no cell in italic before)by applying the fomula <0, then goto find and replace click options find for italic format and replace it with 0 or whataver you want,
☚ Click ★ just below left if it helps, Boo?ath?
If you want to do it in the same cell you will need a macro of sorts.
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks