Functions

O

office type

how do i get multiple functions to compute one answer, i.e. when i want any
number less than 4000 to compute function A and numbers greater than 4000 to
compute function B ext. ext.
 
J

JE McGimpsey

One way:

=IF(A1<4000,<your function A here>, IF(A1>4000, <your function B
here>, "Exactly 4000"))
 

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

How to break up a book's endnotes by chapter in a file containing a whole book? 0
Use TODAY() function as the criteria in a SUMIF formula 1
Using If function for Great and less than function 6
IF function not working 3
cell.address gives strange result 1
Sumif number is greater than a number but less than another number 2
Formula to count data in a column that falls between a range 3
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0

Top