Thread: [Solved] if(and.. formula
View Single Post
 
Old 05-13-2016, 06:18 AM
paxon paxon is offline Windows XP Office 2007
Novice
  
Join Date: Feb 2016
Posts: 13
paxon is on a distinguished road
Default if(and.. formula
Hi..
I am trying to solve the if(and.. formula from the attached file in column "H")

This is what I am trying to do:

if"g8" is = to "C21" then give me "D21" And if "g8" is >"B22" but < than "C22" then give me "D22"... and so on till line 29.

I think that the formula If(And.. is probably a good one but I do not know how to make it.

thanks
Attached Files
File Type: xlsx Book1.xlsx (13.8 KB, 14 views)
Reply With Quote