The scenario is If a business makes a loss of $120 they go to the bank and get $1000, If the loss is $1200 They borrow $2000, and if The Loss is $5900 thery borrow $6000, and finally thay borow Zero if they make a profit
2006-08-05 10:18:09 · 11 answers · asked by kibara 1 in Computers & Internet ➔ Other - Computers
Hema's answer will work, it just needs commas instead of semi-colons and also would be better if the first argument said "IF(A1>=0" instead of just "IF(A1>0" so that a value of 0 would not require a loan of $1000.
2006-08-05 14:24:10 · answer #1 · answered by O Caçador 6 · 0⤊ 0⤋
i'm sorry it's little complix , but that's all that i could think of in such short notice, OK
*if the number (loss/profit) is in the cell A1 then the formula would be:
=IF(A1>0;0;-1000*
TRUNC(((ABS(A1)
+1000)/1000);0)) , sorry i had to write it like that in order to show it right
2006-08-05 10:36:48 · answer #2 · answered by Anonymous · 1⤊ 0⤋
This should work
it evaluates a1 to see if less than 0, if so it turns the amount to the next thousand down then adds 1000 to it.
=if(a1>-.01,0,int(abs(a1)/1000)*1000)
2006-08-05 10:28:21 · answer #3 · answered by sethsdadiam 5 · 0⤊ 1⤋
Use the 'round' function in the equation, it might be RND or ROUND. Use the IF statement also to discriminate between profit and loss.
2006-08-05 10:22:01 · answer #4 · answered by Chris cc 1 · 0⤊ 1⤋
=roundup(A1/1000,0)*1000
whre A1 is the cell with 120 or 1200 or whatever
2006-08-05 10:21:47 · answer #5 · answered by Anonymous · 0⤊ 0⤋
you do an =- formula, then reduce the zero's to whatever u want
hope that makes sense!
2006-08-05 10:22:55 · answer #6 · answered by mariamayo9 2 · 0⤊ 0⤋
=if(A2=-120,-1000)
2006-08-05 10:23:17 · answer #7 · answered by Rich M 3 · 0⤊ 0⤋
muppett take 1 away
2006-08-05 10:21:44 · answer #8 · answered by Anonymous · 0⤊ 1⤋
Answer Loading.....
2006-08-05 10:19:57 · answer #9 · answered by Tommy vercetti 2 · 0⤊ 1⤋
x*(-1000)=n
Try this, and let me know how you make out.
2006-08-05 10:22:17 · answer #10 · answered by nora22000 7 · 0⤊ 0⤋