Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell formulae do nothing
I have created a formulae that asks if A1 = B1 then return the number 3 and
if not do nothing (for example =IF(A1=B1,3,"") and it works fine as long as there are numbers there. My problem is that i want to set up a table and this equasion has been draged down the page but when the cells are blank it returns a 3 (because both cells are the same) and i only want it to show when a number has been inserted to the relavant cells. Please help it's driving me nuts. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell formulae do nothing
=IF(AND(A1=B1,A1<""),3,"")
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Paul" wrote in message ... I have created a formulae that asks if A1 = B1 then return the number 3 and if not do nothing (for example =IF(A1=B1,3,"") and it works fine as long as there are numbers there. My problem is that i want to set up a table and this equasion has been draged down the page but when the cells are blank it returns a 3 (because both cells are the same) and i only want it to show when a number has been inserted to the relavant cells. Please help it's driving me nuts. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=IF cell needs to show blank if blank | Excel Discussion (Misc queries) | |||
Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions |