i have 2 size blocks. one is large and costs £1.80 per block,with a pack size of 144 and one is small and costs £1.60 per block, with a pack size of 216.
the 2 pack sizes will appear in cell A. how do i get cell be to register the pack cost at £1.80 for the large and £1.60 for the small? I apologise if this seems really easy but i don't use excel that much. regards
Assuming the pack size is in A1 and there are only the two pack sizes, put the below in cell B1
=IF(A1=144,1.8,1.6)
If I've been of help, please hit the star
Like this?
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
first thing is don't put 2 lots of info in one cell it just makes things awkward excel is really designed for separate info on each cell.
second what you are asking is not clear
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
thank you very much. excellent worked first time!!
what would the follow on eqation be for this cell to work out the 2 total pack prices?
Which of the above methods are you using?
I'm not sure what you mean by this second question. Could you explain a little more?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks