Skip to main content

What am I doing wrong?

  • Mar 31, 2022 2:21 AM UTC
  • 3 replies
  • 52 views

Forum|alt.badge.img+4

Here is my formula

IF({Dept} =Bath, “8.5”, IF({Dept} =Win, “10”, IF({Dept} =ODL, “0” ) ) )

My objective - if field “Dept” is Bath then 8.5, if it is Win then 10, if it is ODL then 0

This topic has been closed for replies.

3 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Mar 31, 2022 3:07 AM UTC

Welcome to the Airtable Community!

You need to put quotes around your text strings and not the numbers. You can also use SWITCH instead of nested IFs.

SWITCH( {Dept},
    "Bath", 8.5,
    "Win", 10,
    "ODL", 0
)

Forum|alt.badge.img+4
  • Author
  • New Participant
  • Mar 31, 2022 3:47 AM UTC

Welcome to the Airtable Community!

You need to put quotes around your text strings and not the numbers. You can also use SWITCH instead of nested IFs.

SWITCH( {Dept},
    "Bath", 8.5,
    "Win", 10,
    "ODL", 0
)

I apologize - this is probably a dumb question… do I need to take spaces out. If I copy and paste I get an error.


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Mar 31, 2022 4:02 AM UTC

I apologize - this is probably a dumb question… do I need to take spaces out. If I copy and paste I get an error.


Looks like some curly quotes snuck in when I was typing on my phone. I straightened them. You can try copy/pasting again.