Jun 09 2021 12:09 PM
Hi
I have a spreadsheet with people who pay membership rate and guest rate
I'm trying to create a formula for the member/ guest rate column where
if (amount)= $325, then "GUEST"
or if (amount) = 276.25, then "MEMBER"
any other (amount) the field should remain blank.
What formula should I use in the member/guest rate column to make this work?
thanks, Melanie
Account | Clr | Amount | member/ guest rate |
4000-40 Live Study Income:Tuition - Advanced Classes | 276.25 | #VALUE! | |
4000-99 Live Study Income:Tuition - Discounts | -176.25 | FALSE | |
4000-99 Live Study Income:Tuition - Discounts | -25.00 | FALSE | |
4000-10 Live Study Income:Tuition - Foundations | 150.00 | FALSE | |
4000-10 Live Study Income:Tuition - Foundations | 276.25 | FALSE | |
4000-20 Live Study Income:Tuition - Inner Transformation | 276.25 | FALSE | |
4000-99 Live Study Income:Tuition - Discounts | -48.75 | FALSE | |
4000-40 Live Study Income:Tuition - Advanced Classes | 276.25 | FALSE | |
4000-40 Live Study Income:Tuition - Advanced Classes | 325.00 | #VALUE! | |
4000-40 Live Study Income:Tuition - Advanced Classes | 325.00 | guest |
Jun 09 2021 12:28 PM
SolutionJun 09 2021 12:28 PM
SolutionPerhaps you mean
= IF(amount = 325, "GUEST", IF( amount = 276.25, "MEMBER", "") )