I tried using checkboxes with letters for results and no results, that code is here
IF(weeklypayroll=w, employnumber*auditminutessaved, IF(biweeklypayroll=b, employnumber*auditminutessaved/2, IF(semimonthlypayroll=s, (employnumber*auditminutessaved*24)/52)))
and the field I need, Total Minutes Saved Weekly, shows #VALUE! in the field
Thanks,
James
No help? I’ve tried that IF statement a million different ways :sadno
I don’t know if this will help anyone who (like me) has been struggling for hours to get the IF function in emails to perform based on Radio Button check / uncheck button status / values.
I have a facility booking page where to select a Morning booking, I have a radio button with the ID morningall; the unchecked value of morningall is 0 (zero), and the checked value is 15.
First off I have had to create a non-visible output element morningallfmt – whose value was morningall – because no amount of experimenting allowed me to get anything working by coding IF(morningall=15, “This is booked”,”This is not booked”) to function.
To my annoyance, coding IF(morningallfmt=15, etc etc did not work either.
My breakthough (I think, because it works..) was to resort to sticking the IF expression within parentheses (…) placed within a double curly {{……}} place holder, so that the code is
{{(IF(morningallfmt=15, “This is booked”, “This is not booked”))}}
– and result! Works fine!
You really have to keep a clear head about which () parentheses are ENCLOSING the expression, and which are PART of the expresion
Hope this helps a few people, and Igor, if you’re watching and have a shorter way to get here (like did I miss something obvious in the Functions Reference?) – I’ll be very interested!
James,
Here is the code I’m using in a similar instance. This code is for determining quantity based pricing per unit.
IF(q<=749,0.05,IF(q<=9999,0.04,IF(q>=10000,0.03)))
I’ve fixed your code how I would put it..
IF(payrollfrequency=”weekly”,(auditminutessaved*employnumber),IF(payrollfrequency=”biweekly”, ((auditminutessaved*employnumber)/2),IF(payrollfrequency=”semimonthly”,((employnumber*auditminutessaved*24)/52))))
No spaces after anything, additional parentheses added where I think they are needed. I also notice, “EMPLOYNUMBER” may be a misspelling of employee or employer number? Im just guessing there…