If statement

G

Guest

We have a spreadsheet setup with a formula in cell B1 that is drivin by a
number in cell A1... Below is the formula...

=IF(A1>14<=22, A1-0.75)

i think what is blowing up the formula is the A2>14<=22 ... is there a way
to get a greater than one number but less than another number type function
inside of a formula, please let me know.... thanks...

Jeff
 
P

Peo Sjoblom

=(A1>14)*(A1<=22)*(A1-0.75)

or


=IF(AND(A1>14,A1<=22), A1-0.75)


the difference is that the former retruns 0 if false and the laste returns
FALSE
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Calculate elapsed time excluding specific timeframe 10
Variance Analysis and Excel 1
Scrabble Value calculation for Welsh words 0
Formula help 0
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
Combine results of 2 formulas 2
Nees Function to Split 3

Top