Excel assistance
Closed
njiebadou
Posts
2
Registration date
Tuesday March 3, 2015
Status
Member
Last seen
March 4, 2015
-
Mar 3, 2015 at 06:01 AM
njiebadou Posts 2 Registration date Tuesday March 3, 2015 Status Member Last seen March 4, 2015 - Mar 4, 2015 at 07:04 AM
njiebadou Posts 2 Registration date Tuesday March 3, 2015 Status Member Last seen March 4, 2015 - Mar 4, 2015 at 07:04 AM
Related:
- Excel assistance
- Number to words in excel - Guide
- Excel marksheet - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Mar 3, 2015 at 08:22 AM
Mar 3, 2015 at 08:22 AM
Looks like an "If" statement will do the trick.
Assuming your value is in A1 you might try this:
=IF(AND(A1>5,A1<15),5,0)
You could also set it up so variables are cells
Assuming the target value is 12 and in A3, the min is in A4, the max is in A5, the cost in A6 and the "other" cost is in A6 (you could also use "" to make it blank blank or 0 to show a zero for the "other" cost. You could use
=IF(AND(A3>A4,A3<A5),A6,A7)
What you're doing is saying if the two conditions are both met, use the cost. If not use zero.
As I'm writing it, I'm saying to myself - "IF AND the amount is greater that five and the amount is less than fifteen then five else zero."
Hope that helps.
Assuming your value is in A1 you might try this:
=IF(AND(A1>5,A1<15),5,0)
You could also set it up so variables are cells
Assuming the target value is 12 and in A3, the min is in A4, the max is in A5, the cost in A6 and the "other" cost is in A6 (you could also use "" to make it blank blank or 0 to show a zero for the "other" cost. You could use
=IF(AND(A3>A4,A3<A5),A6,A7)
What you're doing is saying if the two conditions are both met, use the cost. If not use zero.
As I'm writing it, I'm saying to myself - "IF AND the amount is greater that five and the amount is less than fifteen then five else zero."
Hope that helps.
Mar 4, 2015 at 07:04 AM