Dylan driscoll
New Member
- Joined
- Apr 14, 2013
- Messages
- 9
how can I expand the following formula
=IF((F3/(A3-0.58))=0,0,IF((F3/(A3-0.58)-K3)*(A3-0.58)<0,0,((F3/(A3-0.58))-K3)*(A3-0.58)))
to include the following: IFA3<2.5 then (F3/A3)-K3)*A3
=IF((F3/(A3-0.58))=0,0,IF((F3/(A3-0.58)-K3)*(A3-0.58)<0,0,((F3/(A3-0.58))-K3)*(A3-0.58)))
to include the following: IFA3<2.5 then (F3/A3)-K3)*A3