Here's my sheet.

I want to look at column F. If F* is less than $B$4, use the number in the adjacent cell in column E to fill C4.

New contributor
Nicholas Pistor is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Hi and welcome to WebApps. A few things: 1) Please edit your question to provide a description of your scenario that does not require viewing your spreadsheet. At present it is unclear. 2) What exactly is your problem? What have you done to resolve this yourself, what research have you done? 3) Thank you including a spreadsheet; it requires "permission" to open the sheet. Would you please change this to allow anyone with the link to access the sheet.
    – Tedinoz
    Jan 12 at 3:21

Your Answer

Nicholas Pistor is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.