Formula help

LostinLA · #1 05-15-2018, 11:23 AM

What I need is a formula to answer the following.
if cell a1 is a number between 1-121 then I need the formula to output a 1 if not then a 0
I also need to know how to write it if cell a1 is a number between c3-1 to c3-96 need the same output a 1 or a 0

ArviLaanemets · #2 05-15-2018, 12:19 PM

1.

Code:

=(a1>=1)*(a1<=121)

2.

Code:

=(a1>=(c3-96))*(a1<=(c3-1))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Copy Row 2 Row But Next Column In Formula From Another Tab	TimG	Excel	3	04-16-2018 09:20 PM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
help with a formula	srockwell25	Excel	4	08-22-2014 02:47 AM
Formula	muhu	Excel	1	04-14-2014 08:19 AM