Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-13-2016, 06:18 AM
paxon paxon is offline if(and.. formula Windows XP if(and.. formula Office 2007
Novice
if(and.. formula
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
if(and.. formula Formula Help odonnest Excel Programming 8 01-23-2015 07:18 AM
if(and.. formula WHEN formula agent007 Excel 5 02-06-2014 09:20 PM
Formula Help clo312 Excel 11 01-11-2014 02:54 AM
if(and.. formula What formula should I use? TotalONE Excel 3 11-26-2013 01:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft