# Conditional Formula in Excel Microsoft Excel 2007
September 1, 2010 at 17:13:16
Specs: Windows 7
 I'm trying to write a conditional formula for a spreadsheet. I want to have the conditions apply only when one cell (A849) equals the previous cell (A848). As it stands right now, I have the conditions ready to go, but can't quite figure out how to trigger the initial condition stated above.Here are the conditions that I want to apply if, and only if, cell A849 = A848=IF(F849>G848," ",IF(F849=G848," ",IF(F849 See More: Conditional Formula in Excel

#1 September 1, 2010 at 17:43:53
 From what I understand you want the formula:=IF(F849>G848," ",IF(F849=G848," ",IF(F849G848," ",IF(F849=G848," ",IF(F849

Report •

#2 September 1, 2010 at 17:50:53
 Well, there's a bunch of stuff going on here.I'll answer your question first, then mention a few other things:To only have your conditions apply when A848=A849 all you need to do is wrap another IF around your conditions, with your conditions being the value_if_true for the first condition:=IF(A848=A849,IF(F849>G848," ",IF(F849=G848," ",IF(F849G848," ",IF(F849=G848," ",IF(F849 or = conditions.=IF(F849

Report •

#3
September 2, 2010 at 09:42:29
 Thanks, guys!A combination of Mike's response and DerbyDad03 worked perfectly!

Report •
Related Solutions 