Hi there and welcome
You would want this formula assuming the values are in A1
You do not need to do less than 1499 and less than 1550 as if its less then 1550 then it is also less then 1499
Let me know how you go with it please
No sorry, but explain the formula in your own words so I can convert to excels syntax
so example if A1 = this and A2 = that then A3 will equal this else that
where you able to tell me this please?
ok, I work online here as its easier then via the phone.
Let me know please when you have the information
ok, but how I need you to explain the actual rules
So for example
It needs to check if the units in A1 is greater then 190, and the cost in B1 was 1450, then return 100, else return 50
So I can code the formula
ok, but I am not sure why you would not do as I requested....
Just explain the rules in your own words and I can code the syntax.
I marked the question to never close in case you change your mind later.
If you would like any additional information or assistance, please do not hesitate to let me know.
And if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.
i would like to help you with this and i think the solution is probably quite simple, it would be best to get a visual idea of how your sheet is set up. If you could send the actual excel file or something with some example data arranged the same way. I could assist you further
you could send the file to
www.wikisend.com, you do not need to create account to use the service and it is free.
after uploading the file they give you a link, paste that link here.
if wikisend does not work you can try,
or any other file sharing service you use such as drop box or google drive.
just paste the file sharing link for whatever service you decide to user
it would be helpful to view the worksheet
ou could send the file to