Eexcel percentage increase based on formula-CodePudding

I am trying to fill the sell price column in an Excel spreadsheet with the increased values in colors based on the round up columns value (1 to 50 green, 50 to 100 blue, 100 to 150 yellow, 150 pink).

I've opted for the percentage table because some items can be sold for a lot more than what I have purchased them for, so that's just for my benefit. I am open to any other suggestions and I am new to this whole business thing.

I was using IF in my formula which would work great for using one percentage increase in the formula: =IF($E27<50,ROUNDUP(I$27,-1)). If I try to enter a second argument like =IF(OR($E28<50,ROUNDUP(I$28,-1)OR($E28>50,<100,ROUNDUP(J$28,-1)))), I will get an error.

I'm probably using the formulas wrong, I've tried "AND" and a couple other formulas, but I can't find anyone else trying to achieve the same or similar.

CodePudding user response：

So something like this:

=IF($E28<50,ROUNDUP(I$28,-1),IF($E28>50,ROUNDUP(J$28,-1),"Error"))

But not sure what the <100 was for.

CodePudding user response：

Although the problem is not completely clear, I understand that you want to add a formula with nested if statements. I will recommend you to try nested ifs in parts.

=IF($E27<50,ROUNDUP(I$27,-1),"First if condition is false")

If everything is working as per the requirement then edit that text in the formula to add another if statement.

=IF($E27<50,ROUNDUP(I$27,-1),IF(OR(condition 1, condition 2,more conditions),"value if true","value if false"))

In the second argument provided by you, the arguments of the OR function has not been properly provided. Ensure that all the arguments of an OR function are conditions separated by a comma. $E28<50 This is a condition so it's ok. But other arguments are not making sense. Also, using OR multiple times inside the first OR arguments is not clear. It would be beneficial if you could provide the basic table and mention the requirement clearly.