Home |
Search |
Today's Posts |
#1
|
|||
|
|||
check if 2 cells are equal but only if they contain numbers not i.
I want to check if 2 cells are equal but only if they contain numbers nit if
they're empty. At present with the IF function it returns TRUE when the cells are empty and I want it ti retorn FALSE if the cells are empty |
#2
|
|||
|
|||
=IF(ISBLANK(someCell),"TRUE")
If the cell is empty "TRUE", else "FALSE" hth "Peter Boardman" <Peter wrote in message ... I want to check if 2 cells are equal but only if they contain numbers nit if they're empty. At present with the IF function it returns TRUE when the cells are empty and I want it ti retorn FALSE if the cells are empty |
#3
|
|||
|
|||
One way
=AND(A1<"",A1=B1) -- Regards, Peo Sjoblom "Peter Boardman" <Peter wrote in message ... I want to check if 2 cells are equal but only if they contain numbers nit if they're empty. At present with the IF function it returns TRUE when the cells are empty and I want it ti retorn FALSE if the cells are empty |
#4
|
|||
|
|||
Try this:
=AND(A1=A2,A1<0) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Peter Boardman" <Peter wrote in message ... I want to check if 2 cells are equal but only if they contain numbers nit if they're empty. At present with the IF function it returns TRUE when the cells are empty and I want it ti retorn FALSE if the cells are empty |
#5
|
|||
|
|||
=AND(A1<"",B1<"",A1=B1)
-- HTH RP (remove nothere from the email address if mailing direct) "Peter Boardman" <Peter wrote in message ... I want to check if 2 cells are equal but only if they contain numbers nit if they're empty. At present with the IF function it returns TRUE when the cells are empty and I want it ti retorn FALSE if the cells are empty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to verify that 3 cells are equal | Excel Worksheet Functions | |||
check if 2 cells are equal but only if they contain numbers not i. | Excel Worksheet Functions | |||
Protecting certain cells only & Spell check | Excel Discussion (Misc queries) | |||
How to verify that 3 cells are equal | Excel Worksheet Functions | |||
A formula to check differrent cells | Excel Worksheet Functions |