If And Statement formula

[Jon3sy]

Hi there Legends of Excel

I am having trouble with my formula - I am trying to write a formula if G48+H48=2192909 and adding it to C162 and if Est Opt3 I4 is greater than or =to this value then I want the fixed value of $179,235.50 else do F46*I163.

=if('Est Opt 3'!I4,"","",If((and('Est Opt 3'!I4>='Graphs Opt3'!$C$162,'Graphs Opt3'!$G$48+'Graphs Opt3'!$H$48=2192909)),"179235.50",$F$46*$I163)

thanks in advance

 

[kpasa]

You're missing quite a few elements and your written explanation doesn't make full sense. Can you clarify?

 

[jtakw]

Hi,

Based on your description, see if this does what you want (Don't put quotes around the numeric result "179235.50", that makes it Text):

Book1
	J
1	#REF!
Sheet110

Cell Formulas
Range	Formula
J1	=IF('Est Opt 3'!I4="","",IF(AND('Est Opt 3'!I4>='Graphs Opt3'!$C$162+'Graphs Opt3'!$G$48+'Graphs Opt3'!$H$48,'Graphs Opt3'!$G$48+'Graphs Opt3'!$H$48=2192909),179235.5,$F$46*$I163))

 

[Jon3sy]

Thank you for your help - I revised my formula and I got it to do what I needed it to. It was much simpler than I was trying to do. thanks for your time.

 

[jtakw]

You're welcome.