Skip to main content

Post content has been hidden

To unblock this content, please click here

Beginner

Quick Excel help pls - @if's with multiple parameters....

Mrs Vineweevil, 13 July, 2009 at 21:59 Posted on Off Topic Posts 0 1

Saved

Reply

Report
Hide content

I want a formula to say @if(cellA1 = 1-3 then the answer is one, if cell A1 is 4-6, then the answer is 2, etc etc......any ideas???

Report
Hide content

1 replies

Latest activity by nutfluff, 14 July, 2009 at 08:15

Beginner September 2007
Baby Buns · 13 July, 2009 at 22:04
Report

Hide content
=if(a1,1,if(a1<6,2,3)) or something like that - you might to need to play with the order of the parameters
- Reply

Beginner September 2008
nutfluff · 14 July, 2009 at 08:15
Report

Hide content
=IF(A1<=3,1,IF(A1<=6,2,IF(A1<=9,3,"")))

So basically WBBS, except if you put<=, it is less than or equal to your maximum IYSWIM
- Reply

Win £3,000 for your wedding

Join Hitched Rewards, where you can win £3,000 simply by planning your wedding with us. Start collecting entries, it's easy and free!