Unable to derive Simple Multiplication result with IF(AND.... Cell Value 0 or Blank

[RapchikM]

Hello
Can anyone help me to correct the following formula uisng IF(AND....

I am trying to put value in Cell E57 as 0 or leave E57 as blank then Why does the following formula don't work ?
in cell H57 i ve incorporated the following formula
=IF(AND(E57="",E57=0), D57*1*F57, D57*E57*F57)

if Cell E57 = 0 then Multiplication result is derived But if Cell E57 is Blank then H57 = 0 instead of Calculated value

How can i derive a simple mulitplication result with Cell incoropated with 0 , 0.00 and with Cell Blank


RapchikM

 

[Peter_SSs]

Your description is not entirely clear to me but perhaps you just need to change AND to OR?

=IF(OR(E57="",E57=0), D57*1*F57, D57*E57*F57)

or if E57 does not contain a formula, perhaps just this

=D57*IF(E57=0,1,E57)*F57

 

[RapchikM]

Dear Sir Peter_SSs

Thank you so much for the perfect result although i was not clear.

I thought to use IF Cell E57 = 0 AND Cell E57 is Blank to get the correct result

What made you use IF(OR.......

Very much grateful to you for your immediate response?

RapchikM

 

[Peter_SSs]

What made you use IF(OR.......

I used OR because that is what you want.
That is, you want to multiply by 1 if E57 is blank OR if E57 is 0.

Did you try the second formula too?

 

[RapchikM]

Sir Your Second formula just tried Result was Perfect too

But with your second formula how to write for the following condtiion
=IF(OR(E16="",E16=0), D16*1*F16, (D16*E16*F16)/100)

RapchikM

 

[Peter_SSs]

Sir Your Second formula just tried Result was Perfect too

But with your second formula how to write for the following condtiion
=IF(OR(E16="",E16=0), D16*1*F16, (D16*E16*F16)/100)

RapchikM

That formula does not really lend itself to the form of the second formula I used above. I suggest you just use this formula.

 

[RapchikM]

That formula does not really lend itself to the form of the second formula I used above. I suggest you just use this formula.

Well in that case i will use your 1st formula for the changes i showed in post #5
Thank you so much for the guidance ?

RapchikM

 

[Peter_SSs]

You're welcome.

 

[RapchikM]

Sir May be with your permission Last question if you may allow

How could i Use SUMIF with following formula
=IF(OR(E16="",E16=0), D16*1*F16, (D16*E16*F16)/100)

my range is from E16: F21
RapchikM

 

[Peter_SSs]

How could i Use SUMIF with following formula
=IF(OR(E16="",E16=0), D16*1*F16, (D16*E16*F16)/100)

my range is from E16: F21

That is not clear to me. With the sample below, what result would you expect and how do you calculate it manually?

21 05 05.xlsm
	D	E	F
16	1	3	7
17	2	0	8
18	3	1	9
19	4		10
20	5	3	11
21	6	0	12
Sample