mbhm1
Forum Replies Created
-
Forum: Plugins
In reply to: [Calculated Fields Form] Formula with multiple conditionsThat worked perfectly – thank you!
It is working perfectly – thank you! Interestingly, that is what is required in excel also, but I had removed it here at the beginning thinking it was not required.
Again, many thanks!
Done – thanks.
Great – that solved that problem (my apologies for not picking up that error myself), and I no longer get any error message. However, no matter what number value is put in cell B3, the formula as written always picks up the number in cell I64. For example, if the number in cell B3 is 58, it should pick up the number in cell I94 (ie 58 is >50 but <61) but instead it is picking up the number in cell I64, which is the first condition, which is clearly not being met. If I change the number in cell B3 to 64, it still picks up the number in cell I64.
I have tried all sorts of permutations and comibinations, with no luck. Is it possible that multiple conditions do not work with this plugin?
Sorry, I was getting that message on the ‘Preview’ of a table.
When I embed the shortcode on the page, I get this error message:
!ERROR! wrong number of arguments (1 given, 3 expected)