Multiple IF Functions

1. Multiple IF Functions

Hi,

I want to set up a formula where a given number in cell A1 between 1-20 will come up with text A if the given number is 1-9, text B if it is between 10 and 14 and text C if it is above 15 (ie. 15-20). I would want this text to appear in cell A2 as the original given number would still need to be visible.

I hope I've explained that well as I haven't put it into context of my spreadsheet but that would just complicate things further.

Any help would be appreciated.

Cheers.

2. Try

=Lookup(A1,{1,10,15},{"A","B","C"})

3. No luck with that sorry. After I enter the formula it deletes the {"a","b","c"} part too for some reason.

4. It shouldn't

try pasting it in the formula bar at top.

or try:

=LOOKUP(A1,{1,10,15;"A","B","C"})

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1