thewolfdead
New Member
- Joined
- Sep 23, 2016
- Messages
- 24
Dear All,
<tbody>
</tbody>
I believe that I have the write multiple IF formula but I keep getting a "#VALUE!" return on the cell. The goal is that depending on the line item @Size, a different calculation is made for its respective @Lot Price:
=IF([@Size]="10kg", ([@[Lot Price]]*(1.5))),IF([@Size]="5kg",([@[Lot Price]]*1.5/3)), IF([@Size]="1kg",([@[Lot Price]]*1.5/6))
I have reviewed it many times and referred to websites...I do not believe that the OR function will assist me.
Any advice would be greatly appreciated.
Regards,
D
Lot Price | Individual Price | Item | Size |
$50 | formula goes here<formula goes="" here=""><insert formula=""></insert></formula> | Product A | 1kg |
$75 | formula goes here<formula goes="" here=""><insert formula=""></insert></formula> | Product B | 5kg |
$100 | formula goes here<formula goes="" here=""><insert formula=""></insert></formula> | Product C | 10kg |
<tbody>
</tbody>
I believe that I have the write multiple IF formula but I keep getting a "#VALUE!" return on the cell. The goal is that depending on the line item @Size, a different calculation is made for its respective @Lot Price:
=IF([@Size]="10kg", ([@[Lot Price]]*(1.5))),IF([@Size]="5kg",([@[Lot Price]]*1.5/3)), IF([@Size]="1kg",([@[Lot Price]]*1.5/6))
I have reviewed it many times and referred to websites...I do not believe that the OR function will assist me.
Any advice would be greatly appreciated.
Regards,
D
Last edited: