Excel

[Bruno_A]

Hey guys, I want the cell D44 to show "5%" if the value in G35 is between 999 and 1999 and to display "10% if G35 is 2000 or more. How could I do this? I just started IF statements. Can anyone help here? Thanks

 

[vanished]

yes, in cell D44, put

Quote

=if(and(G35>999,G35<1999),"5%",if(G35>=2000,"10%",""))

Edit: I tested it and it works

 

However I should say though that your conditions are incomplete.  What happens if the value is under 999?  I have it set to be blank above.  What happens if the value is between 1999 and 2000?  Currently that also goes blank, and is not independently addressable.

[Bruno_A]

32 minutes ago, Ryan_Vickers said:

yes, in cell D44, put

Edit: I tested it and it works

 

However I should say though that your conditions are incomplete.  What happens if the value is under 999?  I have it set to be blank above.  What happens if the value is between 1999 and 2000?  Currently that also goes blank, and is not independently addressable.

It does work mate, thanks a lot. It's for college, and we haven't been in depth on IF statements. The formula you provided helped me better understand more complex IF statements. I was around that for a quite a while before making a post. Thanks a lot, I was able to finish my excel sheet because of that. Also, I set it to be 0% if the value is under 999 

 

[vanished]

Just now, bruny06 said:

It does work mate, thanks a lot. It's for college, and we haven't been in depth on IF statements. The formula you provided helped me better understand more complex IF statements. I was around that for a quite a while before making a post. Thanks a lot, I was able to finish my excel sheet because of that.

 

They're pretty basic, it's just IF(<condition>, <show this if it's true>, <show this if it's false>), and then of course you can nest additional things as needed.  Don't be afraid to check google for the definition/use of a function you come across, they're all well documented.  Glad I could help though

[Bruno_A]

7 minutes ago, Ryan_Vickers said:

They're pretty basic, it's just IF(<condition>, <show this if it's true>, <show this if it's false>), and then of course you can nest additional things as needed.  Don't be afraid to check google for the definition/use of a function you come across, they're all well documented.  Glad I could help though

Yeah, they are, the thing is, I didn't know how to display "5%" if the value was between 0 and 999 as I didn't know how to put "between 0 and 999" in the formula, but I really didn't need to do that, as I could put two logical values in. This helped a lot, really, It may have been you doing the formula, but I truly understand it and could replicate it by myself, which was my goal.

[vanished]

2 minutes ago, bruny06 said:

Yeah, they are, the thing is, I didn't know how to display "5%" if the value was between 0 and 999 as I didn't know how to put "between 0 and 999" in the formula, but I really didn't need to do that, as I could put two logical values in. This helped a lot, really, It may have been you doing the formula, but I truly understand it and could replicate it by myself, which was my goal.

Ah, yeah, if you have a slightly more complex condition, you can use AND, OR, etc. to combine multiple things as needed

 

Above was my attempt to answer exactly what you asked, but if I were to take a guess at what is really intended and design something for that, I might do it like this:

Quote

=IF(G35>=2000, "10%", if(G35>=1000, "5%", if(G35>=0, "0%", "N/A")))