jdcollins88
New Member
- Joined
- Jan 28, 2013
- Messages
- 5
Hello, I am trying to fill in the Net height in the below table based on the Net assignment located next to species. If Net=A then Net height should = 2.6 for MYLU but should be 10.4 for MYSO. I've tried a nested IF function =IF(B1="A",C1 IF(B1="B", D1)) but it returns an error. I could do it by hand if I didn't have 10K records
<tbody>
</tbody>
Thanks for the help.
Jason
Species | Net | Net A Height | Net B Height | Net Height |
MYLU | A | 2.6 | 5.2 | |
MYSO | A | 10.4 | 10.4 | |
MYSE | B | 5.2 | 2.6 | |
MYSE | A | 10.4 | 2.6 |
<tbody>
</tbody>
Thanks for the help.
Jason