I'm trying to create a calculator type formula - where if the qty (say 25) entered in a cell is higher than 10 but lower than 49 then multiply by cell A1.
this would continu until i had cover the different qty breaks (numbers entered) against the cost per item
can any one help
regards
P
this would continu until i had cover the different qty breaks (numbers entered) against the cost per item
can any one help
regards
P