Hello all,
I’m trying to figure out a clean way of writing a formula for a Lookup table that can hold up to 4 variables at any time (A,B,C,D).
Based on these variables, I want the formula output the following:
IF(Lookup contains: “A or B or C or A,B ...
Hello all,
I’m trying to figure out a way to randomly generate a 6 digit randomized number for confirmation use on future bookings. So far I’ve come up with using ‘Autonumber’ and a formula to add six 0’s as a prefix. However, I’d like the number to ...
Hello all,
I’m trying to create an IF(AND( condition for the following statement and seem to be doing something wrong:
IF(AND({Nr. Of Payments}=“2 Payments”, {Deposit Made}=FALSE()),“2 Payments Left”,
IF(AND(Nr. Of Payments} =“2 Payments”, {Deposit M...
Thanks so much! This was perfect!! I’ve never used the concatenate function before, but now that I have, it makes so much more sense to make use it. So awesome! Thanks again!
Didn’t know that was an option. Will have to look into it.
On another note, do you happen to know if it’s possible to set a formula to return the following:
IF “Trip Name” is “Paris”, AND departure date is greater or equal to 90 days, AND “Room Type”...
Not at all! That’s a great idea though!! Then I can use a formula to strip away the letter and return #'s only. I think that doable. Is it not?
Thanks!
