conditional functions

F

Frank Kabel

Hi
- choose formula
- enter something like
=AND(A1=1,B1=2)

--
Regards
Frank Kabel
Frankfurt, Germany

j said:
does anyone know how to create a conditional formula with two
Click to expand...
conditions???
 
K

K.S.Warrier

Hi,
Try this,if it suites you.
If A1 contains one value & B1 contains another value,then in C1
=if(A1>=4,if(A1<15,B1,"")) ie,if A1 is >=4 & <15, value will be B1
otherwise ""(blank)
Thank you,
K.S.Warrier
 

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

Resource name inside resource sheet: per person, work per hours per week 0
Mail Merge Directory Conditional Page Break 0
Conditional Formatting question.... 1
Returning 1 of 4 values if conditions are met 4
Conditional Formatting 3
How can i put text in a cell depending on colour 0
Adding data to MS Access from csv file 0
nested IF without repeating the condition? 1

Top