Related:
- FORMULA QUESTION???
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- This question is locked and replying has been disabled. - Facebook Forum
4 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 21, 2010 at 10:36 AM
Oct 21, 2010 at 10:36 AM
Hi Sloblox,
Use nested IF's.
Your five cells have range A1:A5.
Your input cell is B1.
Then C1 or whatever cell:
Helpfull?
Best regards,
Trowa
Use nested IF's.
Your five cells have range A1:A5.
Your input cell is B1.
Then C1 or whatever cell:
=IF(B1=A1,"positive",IF(B1=A2,"positive",IF(B1=A3,"positive",IF(B1=A4,"positive",IF(B1=A5,"positive","negative")
Helpfull?
Best regards,
Trowa
=IF(B1=A1,"Positive",IF(B1=A2,"Positive",IF(B1=A3,"Positive",IF(B1=A4,"Positive",IF(B1=A5,"Positive","Negative")))))
i have 5 numbers (they are actually 5 different lengths of timber) 2.4,3.0,3.6,4.2 & 4.8 what i am trying to do is get excel to calculate from a number that is input by the user , which of the 5 different lengths would be the most suitable......ie if you entered 2.4 as your length , then obviously excel would select 2.4, but if you entered 3.3 , then the closest number greater than 3.3 would be 3.6 , in addition to this , is it possible for excel to calculate from the number input if it is much bigger using multiples of the 5 lengths available.....ie lets say you input 5.4 , then a combination of 2.4 & 3.0 would be ideal , is this possible.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 26, 2010 at 09:37 AM
Oct 26, 2010 at 09:37 AM
Hi Sloblox,
This is a totally different question than what you started out with!
Try this formula:
When you enter 3.3 in cell B1 the result will be 3.6, since this is the bigger number that is closest to the input number.
When you enter a number that is bigger then the number entered in A5 the text "Use multiple sizes" will be visible.
Sorry, but I have no idea how to look for a combination of numbers to come close to the input number.
Hopefully this formula will be of some use for you.
Best regards,
Trowa
This is a totally different question than what you started out with!
Try this formula:
=IF(CEILING(B1,A1)=A1,A1,IF(CEILING(B1,A2)=A2,A2,IF(CEILING(B1,A3)=A3,A3,IF(CEILING(B1,A4)=A4,A4,IF(CEILING(B1,A5)=A5,A5,"Use multiple sizes")))))
When you enter 3.3 in cell B1 the result will be 3.6, since this is the bigger number that is closest to the input number.
When you enter a number that is bigger then the number entered in A5 the text "Use multiple sizes" will be visible.
Sorry, but I have no idea how to look for a combination of numbers to come close to the input number.
Hopefully this formula will be of some use for you.
Best regards,
Trowa
Oct 21, 2010 at 01:30 PM
hope i have explained that better this time ... thanks