Fill specific cell depending on the number provided in a cell

Not neccessarily a VBA question but try this

Place this code in cell D1

=if(and(b1<=0.5,b1>=0.1),b1,"")

in B1, type any number from .1 - .5 and it will show in D1. anything lower than .1 or higher than .5 will not be displayed

Originally Posted by usafmeinweg

Not neccessarily a VBA question but try this

Place this code in cell D1

=if(and(b1<=0.5,b1>=0.1),b1,"")

in B1, type any number from .1 - .5 and it will show in D1. anything lower than .1 or higher than .5 will not be displayed

Thanks for giving the prompt solution and apologize for posting in the wrong forum . I still have one piece in this puzzle if you can solve it.

Let’s say Cell “D1” gets the value base on the above provided formula. In case of this fulfillment, now Cell “E1” wants to be automatically filled in taking value from Cell “F1” which has some value plugged in.

ok, if I understand you correctly, if and only if D1 gets calculated you now want cell E1 to be filled in using the value from F1. Can F1 be anything? Will E1 do any calculations such as multipling D1 and F1.
If you have a sample workbook that you can upload, it may help out a bit

Originally Posted by usafmeinweg

ok, if I understand you correctly, if and only if D1 gets calculated you now want cell E1 to be filled in using the value from F1. Can F1 be anything? Will E1 do any calculations such as multipling D1 and F1.
If you have a sample workbook that you can upload, it may help out a bit

I attached the excel sheet with the situation explanation (in blue writing). If it is still not clear then I will prepare a sample sheet with the problem as I have.

Thanks for helping me and being patient to understand the situation to find the solution.

Regards

I think i got what you need. Check the attached to see if I am on the right track. I also adjusted the formulas so that you don't see the annoying #VALUE in blank cells

Originally Posted by usafmeinweg

I think i got what you need. Check the attached to see if I am on the right track. I also adjusted the formulas so that you don't see the annoying #VALUE in blank cells

Thanks for working hard to solve my problem and I apologize for not been able to explain well. I attached excel sheet with an example here (in red writing). I hope this will help a bit. Let me know if you need more explaination or if it is not clear to understand the problem.

Thanks again for all your effort.

Regards

I have H11 and H12 pulling the calculated value from O and AC. Seems no matter what value you plug into H10, AC (correction factor) is always 1.

So with the attacehd workbook, O5=N5*AC5 or 2000*1 = 2000 which is now the value that you see in H12

I must be missing something if this isn't correct. If that is the case, I appologize

Originally Posted by usafmeinweg

I have H11 and H12 pulling the calculated value from O and AC. Seems no matter what value you plug into H10, AC (correction factor) is always 1.

So with the attacehd workbook, O5=N5*AC5 or 2000*1 = 2000 which is now the value that you see in H12

I must be missing something if this isn't correct. If that is the case, I appologize

Hey USAFMEINWEG
Its looks like it is working as we want it to be.
Check the attached copy and confirm.

Regards

Usafmeinweg
I am very grateful for your help, being patient to understand my fuzzy problem and your keen effort to find the solution.

God Bless You

Regards

Originally Posted by ifticalgary

Usafmeinweg
I am very grateful for your help, being patient to understand my fuzzy problem and your keen effort to find the solution.

God Bless You

Regards

Excel File attached.
As I change formulas in cells "H11" and "H12" it is returning with Circular Reference Warning.

Current Cell Formulas: H11: =MAX(AC7: AC9)
H12: =MAX(O7:O9)

Need to change : H11: =MAX(AC7:AC18)
H12: =MAX(O7:O18)

It is giving me circular reference error but some reason it works for current cells.

One of the forum pros helped me before providing formulas for the calculation.

Regards

Give the attached document a try. The formulas that you added from row 9-18 had erroneous formulas. Double check the formulas in column "M" to make sure it's what you wanted.

I also created a macro for you to use the "Clear" button that you had on your sheet. It will erase the data that is in D8 through H10

Regards