I am trying to write a formula that will select a cell value if the following conditions are met.
If cell E2 is more than or equal to the value in cell A2 and also no greater than the value of cell C2 the the value of D2 is copied into cell E3. If E2 is less than A2 or more than C2 then 0 is shown in E3.
Hope you can help
Pablo 1
If cell E2 is more than or equal to the value in cell A2 and also no greater than the value of cell C2 the the value of D2 is copied into cell E3. If E2 is less than A2 or more than C2 then 0 is shown in E3.
Hope you can help
Pablo 1