| View previous topic :: View next topic |
| Author |
Message |
samsanford33
General User
Joined: 01 Sep 2011
Posts: 13
|
 Posted: Thu Sep 01, 2011 8:16 pm Post subject: IF FUNCTION HELP |
 |
|
Ok so here's the formula I have that works:
=IF(J5="L";I5*1.1;-I5)
This formula works pretty good, the only problem is that I have two Values going into the J column, and I don't want a negative number unless the other value is a W. so here is a couple of formulas that I was trying that didn't work
=IF((J4="L";I4*1.1 ,(J4="W";-I4);"")
=IF((J4="L";K4*1.1;IF(J4="W";-K4)"")) |
|
| Back to top |
|
 |
keme
Moderator
Joined: 30 Aug 2004
Posts: 2744
Location: Egersund, Norway
|
| Posted: Fri Sep 02, 2011 12:22 am Post subject: Re: IF FUNCTION HELP |
|
|
| samsanford33 wrote: | Ok so here's the formula I have that works:
=IF(J5="L";I5*1.1;-I5)
This formula works pretty good, the only problem is that I have two Values going into the J column, and I don't want a negative number unless the other value is a W. so here is a couple of formulas that I was trying that didn't work
=IF((J4="L";I4*1.1;),(J4="W";-I4);"")
=IF((J4="L";K4*1.1;IF(J4="W";-K4)"")) |
Your second attempt should work with a little modification on parentheses:
=IF(J4="L";K4*1.1;IF(J4="W";-K4;"")) |
|
| Back to top |
|
|
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
| Posted: Fri Sep 02, 2011 2:33 am Post subject: |
|
|
Moved to Calc.
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot) |
|
| Back to top |
|
|
samsanford33
General User
Joined: 01 Sep 2011
Posts: 13
|
| Posted: Fri Sep 02, 2011 4:12 am Post subject: |
|
|
| Awesome.. I knew I was close. Thanks for the help!! |
|
| Back to top |
|
|
|
