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!
:(
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!
:(
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
Hi read yor equation equation incorrectly, you want to sum a range and if that sum is greater than 59 you want to add 30?
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
Dear all,
thank you for your help.
I managed to find the right formula:
=IF(SUM(B2:B7)>59,SUM(B2:B7)+30)+IF(SUM(B2:B7)<60,SUM(B2:B7))
This works, but maybe there is a shorter version!
😉
Numbers formula, if value is greater