Forum Discussion
no problem, Quickbase formulas are similar to Excel but easier to write and read. Also you can add comments for our own sanity and you only tyopically need to have one IF statement as opposed to Excel where you need to have all those nested IFs.
IF(
([county's # of hospitals] > 0 and [# of hospitals with state programs] >0)
or
([# of hospitals with both] >0, "This county has Both.",
[county # of hospitals with my program] =0 and [# of state programs] > 0,
"This county has state certified programs",
[county # of hospitals with my program] > 0 and [# of state programs]=0,
"This county has my program.",
"This county doesn't have a program".)
.
// by the way f you want to add a comment, then start a line with //
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thank you Mark! You're always so quick to reply and I appreciate you!!
It looks like I might not have been far off the beaten path then. I'm still spitting out an error right off when I use your formula:
Also - when you mentioned adding a comment with // -- do you mean on this thread, or in the Quickbase? Wasn't sure I followed :).
------------------------------
Christine Kirk
------------------------------