[Solved] Need help with an IF function

Discuss the spreadsheet application
Post Reply
lusc8e
Posts: 2
Joined: Thu Jan 11, 2018 8:37 pm

[Solved] Need help with an IF function

Post by lusc8e »

I am trying to create a formula with an IF function that I can't seem to get to work. What I am trying to do is:

IF the value in cell F14 is greater than the value in cell I11, then put 0 in cell F16. Otherwise Multiply cell I11 by 100 and subtract this product from the value in cell F15 and put the results in cell F16.

I can get the first part to work, IF(F14>I11;0) but cannot figure out the rest.

Any help is greatly appreciated!
Last edited by lusc8e on Thu Jan 11, 2018 11:02 pm, edited 2 times in total.
OPenOffice4.1.2 / Win10
lusc8e
Posts: 2
Joined: Thu Jan 11, 2018 8:37 pm

Re: Need help with an IF function

Post by lusc8e »

I finally got it. I used the following:

IF(F14>I11;0;I11*100-F15)

Thanks!
OPenOffice4.1.2 / Win10
Post Reply