Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers formula, if value is greater

Can somene tell me how to make the following formula:

If sum of cells is greater than 59, add 30


In different words


If sum B2:B7 > 59, than +30


Might be simple, but I tried so many options without success!

:(

Posted on Sep 1, 2012 3:59 PM

Reply
4 replies

Sep 10, 2012 7:53 PM in response to milenkostrika

SUMIF B2:B7,">59", + 30


Select = for formulas


Touch function on keypad


From Numeric, Select SUMIF you should get the function filled in on the = line


Touch test values (turns blue) and select the range


Touch condition (turns blue), on the keypad touch "ABC" and enter your condition (>59) touch done


Leave sum values you don't need them


After the last bracket add + 30


Hit the green arrow key, it will sum any number greater than 59 and add 30

Sep 10, 2012 8:42 PM in response to milenkostrika

Can't send you a photo of the equation


Here it is in text


IF(SUM range)>59, (SUM range), 0)+30


Select the if statement, touch the IF expression, select function on keypad, select sum. Touch range select with you finger. Move cursor to right of sum braket and add >59. Touch IF true, select function SUM. Copy previous SUM range, and paste into 2nd SUM range. Touch IF false enter 0. After brackets add +30


You have to copy and paste the range as numbers does not allow you to select the same range twice with you finger!


David

Numbers formula, if value is greater

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.