Multiple IF functions

[dmeasthope]

I am trying to read the data from 2 cells and if both criteria are met to enter something into a new cell, i can use the IF function to read the data from one cell, but I was wondering how i would read from both and only display in the new cell if both are met.

[Tony Valko]

Try something like this...

Let's assume we want to enter the number 10 in cell C1 if cell A1 = X and cell B1 = Y. If either condition is not met then leave cell C1 blank.

Enter this formula in cell C1:

=IF(AND(A1="X",B1="Y"),10,"")

[benishiryo]

hi dmeasthope, welcome to the forum. say the 2 cells are A1 & B1. and criteria is that A1 must be "ABC" & B1 must be "XYZ" for it to read "Yes". otherwise, "No". then try:
=IF(AND(A1="ABC",B1="XYZ"),"Yes","No")

Edit: sorry Valko. i refreshed the page but didnt see your post

[dmeasthope]

Thats great, just another quick one it now displays FALSE if the criteria is not met, is there any way of getting it to display nothing?

[dmeasthope]

Sorry just seen the other post which answers my question, thanks all for the help

[Tony Valko]

You're welcome. Thanks for the feedback!

[Jumbagirl]

I have the the sum of multiple rows of data displaying on a summary page. I want certain values to be subtracted out of that total if certain the description in the preceeding column meets a certain criteria
So for example:

Column A Column B Column C
Sugar Brown 120
Sugar Powder 120
Flour All purpose 120
Flour Self Rising 120
Eggs EARMARK 500


the sum of column C is 980
I also want the sum of column C minus the value of anything numbers whose description in Column B equals "EARMARK" (the total would be 480)

[Jumbagirl]

Sorry the columns didn't stay in place

[Jumbagirl]

This formula would draw information into a summary worksheet, from multiple worksheets with different titles.