Elise Nerlove
Board Regular
- Joined
- Dec 17, 2009
- Messages
- 94
Hi,
I need help with an equation:
If column A = nothing AND column B = nothing, then do nothing. But if a value appears in either column a or b then do the equation: b-a=c
im thinking the equation is: =if(a="",andif(b="","",b-a))
but this is outputting "FALSE" for all rows....any ideas?
Thanks so much for the help!!! greatly appreciated!
I need help with an equation:
If column A = nothing AND column B = nothing, then do nothing. But if a value appears in either column a or b then do the equation: b-a=c
im thinking the equation is: =if(a="",andif(b="","",b-a))
but this is outputting "FALSE" for all rows....any ideas?
Thanks so much for the help!!! greatly appreciated!