Thanks guys, as it is only whole numbers it doesn't matter. However, I've realised I have few blanks so I need the formula below to leave the cell blank if ER is blank:
Try: =IF(ER2>2,"Y","N")
Thanks for any ideas.
Thanks guys, as it is only whole numbers it doesn't matter. However, I've realised I have few blanks so I need the formula below to leave the cell blank if ER is blank:
Try: =IF(ER2>2,"Y","N")
Thanks for any ideas.
![]()
=if(er2="","",if(er2>2,"y","n"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks