command 'IF'
 

HELLO OF EVERYBODY
I would like ask for this :
can i make formula about compare cell for value,and if value= 0 to 5
make A1+B1 ,and if value= 51-100 make A1+C1

Thanks

--
ceconi
-----------------------------------------------------------------------
ceconik's Profile: http://www.excelforum.com/member.php...fo&userid=2806
View this thread: http://www.excelforum.com/showthread.php?threadid=53454

command 'IF'
 

------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://www.excelforum.com/showthread...hreadid=534542
------------------------------------------------------------------------
Question: command "IF"

- compare cell
- if A1 =0-50
------------------------------------------------------------------------

ceconik

You have not listed what cell you are testing the value for. I have
used A7 and you have not listed what to do if value greater than 100. I
am leaving result blank if over 100


=IF(AND(A7=0,A7<=50),A1+B1,IF(A7<=100,A1+C1,""))


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=534542

command 'IF'
 

Try
=IF(A4<=50,A1+B1,A1+C1)

Change A4 to the cell you want to test.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ceconik"
wrote in message
...

HELLO OF EVERYBODY.
I would like ask for this :
can i make formula about compare cell for value,and if value= 0
to 50
make A1+B1 ,and if value= 51-100 make A1+C1

Thanks.


--
ceconik
------------------------------------------------------------------------
ceconik's Profile:
http://www.excelforum.com/member.php...o&userid=28066
View this thread:
http://www.excelforum.com/showthread...hreadid=534542

command 'IF'
 

Try:

=IF(2<ABS(SIGN(0-A1)+SIGN(50-A1)),A1+B1,IF(2<ABS(SIGN(51-A1)+SIGN(100-A1)),A1+C1,0))

Checks value within first range 0-50, if outside, checks within second
range; if outside both ranges, defaults answer to 0.

For maintenance, it would be better to put the range values at a known
location and to use that in the formula.

"ceconik" wrote:


HELLO OF EVERYBODY.
I would like ask for this :
can i make formula about compare cell for value,and if value= 0 to 50
make A1+B1 ,and if value= 51-100 make A1+C1

Thanks.


--
ceconik
------------------------------------------------------------------------
ceconik's Profile: http://www.excelforum.com/member.php...o&userid=28066
View this thread: http://www.excelforum.com/showthread...hreadid=534542

command 'IF'
 

What if target value (A4) is less that minimum value (0)?

"Chip Pearson" wrote:

Try
=IF(A4<=50,A1+B1,A1+C1)

Change A4 to the cell you want to test.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ceconik"
wrote in message
...

HELLO OF EVERYBODY.
I would like ask for this :
can i make formula about compare cell for value,and if value= 0
to 50
make A1+B1 ,and if value= 51-100 make A1+C1

Thanks.


--
ceconik
------------------------------------------------------------------------
ceconik's Profile:
http://www.excelforum.com/member.php...o&userid=28066
View this thread:
http://www.excelforum.com/showthread...hreadid=534542

command 'IF'
 

-----------------------------------------------------------------------
A poll associated with this post was created, to vote and see th
results, please visit http://www.excelforum.com/showthread.php?threadid=53454
-----------------------------------------------------------------------
Question: command &quot;IF&quot

- compare cel
- if A1 =0-5
-----------------------------------------------------------------------

mudraker Wrote:
ceconik

You have not listed what cell you are testing the value for. I hav
used A7 and you have not listed what to do if value greater than 100.
am leaving result blank if over 100


=IF(AND(A7=0,A7<=50),A1+B1,IF(A7<=100,A1+C1,""))

But this formula not work ,example for my problem
I have in A1=14 ,if A1=0-50 formula is A1*1.2
if A1=50-100 formula is A1*1.

--
ceconi
-----------------------------------------------------------------------
ceconik's Profile: http://www.excelforum.com/member.php...fo&userid=2806
View this thread: http://www.excelforum.com/showthread.php?threadid=53454

command 'IF'
 

------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://www.excelforum.com/showthread...hreadid=534542
------------------------------------------------------------------------
Question: command &quot;IF&quot;

- compare cell
- if A1 =0-50
------------------------------------------------------------------------

Just modify Mudraker's formula?

=IF(AND(A1=0,A1<=50),A1*1.2,IF(AND(A150,A1<=100) ,A1*1.5,"Outside
Range"))

ceconik Wrote:
But this formula not work ,example for my problem
I have in A1=14 ,if A1=0-50 formula is A1*1.2
if A1=50-100 formula is A1*1.5


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=534542