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...