Forum Discussion
Formula debug. am i using the wrong formula?
Katrina-
Try using a lookup table instead it will greatly simplify your formula (I've attached an example file for your reference):
=IF(A2>20,ROUNDUP(B2*VLOOKUP(B2,$K$4:$N$10,2,TRUE),0),ROUNDUP(B2*VLOOKUP(B2,$K$4:$N$10,4,TRUE),0))
Try using the Ceiling Function:
| =CEILING(A2,0.25) |
been playing around with it but just cant seem to figure this one out. I've tried placing it in different locations in the formula and with different amounts but cant get it to change just to values under 4$. also tried adding another "if" formula in the function but then i get "you've entered too many arguments for this function". is it just something that will have to be done separately or somehow be done within the VL table? sorry for so many questions I'm new to excel and have been trying to teach myself but some things i don't understand the inner workings of until i see them done. i normally go to youtube or do a google search but this seems to be a tad bit to specific to find out there.
I'm happy to help. Just not quite sure what you're trying to do. Can you please create an example file that has your expected results in one column. So, I can test out a few formulas. This will help me resolve your issue.
I HAVE MY SITUATION DESCRIBED WITHIN THE EXCEL SHEET. IF IT CAN'T BE DONE WITHIN THE CURRENT FORMULA THEN ITS NO BIG DEAL AS I CAN DO THEM MANUALLY. THE FORMULA AS A WHOLE ALREADY SAVES ME MUCH NEEDED TIME THROUGH OUT ALL THE PRODUCTS I'M PRICING EVERYDAY.
***left caps lock on, sorry.
Maybe try using the formula in my attached file. I have left a few comments in it to explain what is happening.