SOLVED

New Contributor

formula help

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
3 Replies
best response confirmed by mgruenwald (New Contributor)
Solution

Re: formula help

Perhaps you mean

``= IF(amount = 325, "GUEST", IF( amount = 276.25, "MEMBER", "") )``

got it thanks!

Re: formula help

@mgruenwald , you are welcome