How To Do It ??

[nasser]

Well I'm So Confused I Can't Think How To Do A Formula To Give Me What I Want In The End .... Any One Can Help Me Plz ???!!
The File Is Attached If Anything Not Clear Plz Just Tell Me

[Don Juan]

not exactly sure what you want. Can you be more specific?

[VBA Noob]

Hi,

Does this work for "first" before I look at "Second"

=IF(A1<1,A1,IF(A1>1,1,1))

VBA Noob

[nasser]

Ty for reply ... well what i mean is
can IF formula return the negative value in some cell to another
and return the value of the same cell if its posstive , to another cell ??

i will talk about the value in the cell I2 ..if it's negative i want the cell to be zero and to return the negative amount to some other cell

and if its positive and more than 1.00 i want it to be in the same cell by just the amount 1.00 and to return what's more than 1.00 to another cell

[MSP77079]

can IF formula return the negative value in some cell to another
and return the value of the same cell if its posstive , to another cell ??

If I parse this question to read as follows: "can [a] formula return ... [a] value ... to another cell?"

Then, the answer is "no". It is impossible to change a value in cell "x" using a formula in cell "y".

[nasser]

sorry mr. but this formula have something wrong
=IF(A1<1,A1,IF(A1>1,1,1))
ty for being here i apricate ur concern

[VBA Noob]

What's wrong then ??

Do you care to expand ??

VBA Noob

[nasser]

Ok Sirs ..may u download my Excel sheet and follow with me
this is a part of a sheet to control the calls of the employers on the mobiles of the company
so .. there is a limit for the calls
and there is a limit for the SMS
if the employer has accrossed any of those limits so he will have to pay that from his pocket

now
lets say that's A3 is the total amount of the invoice and it's 25.00
and C3 is the limit of the calls and it's 15.00
and F3 is the limit of the SMS and it's 1.00

the invoice details saying that he used 20.00 for calls and 5.00 for SMS

i think now it's very clear

what is want is 3 cells
the first 1 to put in it the calls amount (20.00)
the second one is to put in it the SMS amount (5.00)
the third one is to give me the invoice total

i'm online now still and thanks for both of u for being here

[VBA Noob]

I assume this is for second sheet....which I said I didn't look at ??

Still waiting to here what was wrong with the first one

VBA Noob

[nasser]

Sir both of them is one sheet but i give them in 2 sheets to explain it in the 2 cases (if the employer not accross the limit, and if he accrossed it)
all should be in same row ... i wasnt know how to explain it , but now i send it all above this mes.
the wrong with the formula i don't know but it not accept it cause of a coma or something thats all

[nasser]

DEAR VBA... i want to thank you very much and to tell u that this IF+IF i working very well and it's ok

thankh you again wish u alot of good luck in ur life

best regards