Forum Discussion
IFS Formula is giving me fits
Mac or not, in Excel are to be used straight quotation marks, not curve ones. Even if on Mac they are default for text editing. In addition, numbers are to be returned as numbers, not as texts. Plus it's better to add condition if no one from previous is met. Finally
=IFS(P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 10 min 901-1,800 words",590.63, P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 120 min 15,001-20,000 words",2187.5, P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 30 min 1,801-5,500 words",853.13, P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 5 min 0-900 words",350, P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 60 min 5,501-9,500 words",1312.5, P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 90 min 9,501-15,000 words",1750, TRUE,0 )
Takmil I should have mentioned I am using a Mac and that's what the quotations look like. Just in case, I gave it a shot, and that did not do the trick. Thanks though.
Mac or not, in Excel are to be used straight quotation marks, not curve ones. Even if on Mac they are default for text editing. In addition, numbers are to be returned as numbers, not as texts. Plus it's better to add condition if no one from previous is met. Finally
=IFS(P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 10 min 901-1,800 words",590.63,
P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 120 min 15,001-20,000 words",2187.5,
P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 30 min 1,801-5,500 words",853.13,
P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 5 min 0-900 words",350,
P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 60 min 5,501-9,500 words",1312.5,
P11="DRTV_Long Form TV or Radio Broadcast Documentary - up to 90 min 9,501-15,000 words",1750,
TRUE,0
)
SergeiBaklan you are indeed correct, and my apologies for not letting you know sooner. Learning that I needed to change my quotations to straight, and then figuring out how to do that, was followed by taking your suggestion regarding the numbers, and adding the argument TRUE,0 at the end of each formula. I have a fully functioning rate sheet now. Thank you!