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!
[Solved] Need help with an IF function
[Solved] Need help with an IF function
Last edited by lusc8e on Thu Jan 11, 2018 11:02 pm, edited 2 times in total.
OPenOffice4.1.2 / Win10
Re: Need help with an IF function
I finally got it. I used the following:
IF(F14>I11;0;I11*100-F15)
Thanks!
IF(F14>I11;0;I11*100-F15)
Thanks!
OPenOffice4.1.2 / Win10