Home |
Search |
Today's Posts |
#1
|
|||
|
|||
div
can i put a formula to stop div/0 in the formula cells
should there be no data in the cells making up the data? thanks for your help rob |
#2
|
|||
|
|||
rob wrote:
can i put a formula to stop div/0 in the formula cells should there be no data in the cells making up the data? thanks for your help rob Certainly. try +IF(A1=0,"",A2/A1) |
#3
|
|||
|
|||
Thank you
-----Original Message----- can i put a formula to stop div/0 in the formula cells should there be no data in the cells making up the data? thanks for your help rob . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|