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

 

[RapchikM]

Sir,

Because when column E is 0 you want to multiply by 1. Since everything is divided by 100 at the end of my formula I need 100 here so that at the end for any 0 rows the calculation will be 100/100 which is 1 as you want.

Oh Ok. Thank you for clarification

What about this (still confirmed with Ctrl+Shift+Enter)

Very much confirmed. Sir I am now putting my self into practice of Pressing F2 Formula appears and then with (Ctrl+Shift+Enter) As it may take some time to get use to it as i have always the habit of pressing ENTER only.

=(SUMPRODUCT(D16:D18*IF(E16:E18=0,100,E16:E18)*F16:F18)+D19*(C20-E19)*F19)/100

Perfect Sir, Thank you so much ?
At present this was the criteria and you have provided exact Result.

What if criteria changes tomorrow or may be in future. Will i be able to continue on this thread or completely come up with New thread to get really valuable input, guidance and solution

Thank you once more Sir, Really appreciate spending your valuable time on guiding and solving

RapchikM

 

[Peter_SSs]

Sir I am now putting my self into practice of Pressing F2 Formula appears and then with (Ctrl+Shift+Enter) As it may take some time to get use to it as i have always the habit of pressing ENTER only.

Just remember that most formulas will not require the Ctrl+Shift+Enter confirmation so I would not be trying to develop that entry as a habit. ?

Perfect Sir, Thank you so much

You're welcome.

What if criteria changes tomorrow or may be in future. Will i be able to continue on this thread or completely come up with New thread

It depends on how close the new question is to the old one. Many possible helpers will now not be looking at this thread since it already has >20 posts so a new thread may be better. You can always include a link back to this thread in your new one if you think helpers need to look at what was done here.

 

[RapchikM]

Just remember that most formulas will not require the Ctrl+Shift+Enter confirmation so I would not be trying to develop that entry as a habit. ?

Yes Only When Ctrl+Shift+Enter confirmation is required.

it depends on how close the new question is to the old one. Many possible helpers will now not be looking at this thread since it already has >20 posts so a new thread may be better. You can always include a link back to this thread in your new one if you think helpers need to look at what was done here.

Ok Sir Will respect your view and may incorporate this thread ref no in new thread if required

Thank you once more Sir

RapchikM