Experts, if C39 = text then I would need the result to be "Does not Drop Down" and return the formula if otherwise. I do not know how to write if C39 = some text or letters.
thank you
I get a #Value:
=IF(C39=" ","Does not Drop Down"),$C$40*$B$42+($B$26*$B$40*($B$43/365))+($C$41*$B$45)+($B$26*$B$41*($B$46/365))+(($B$26*$B$49)*$B$51)+($B$26*$B$49*($B$52/365))+(($B$26*$B$50)*$B$54)+($B$26*$B$50*($B$55/365))
=IF(C39="Does not Drop Down",C39,$C$40*$B$42+($B$
If you explain the scenario where the first formula didn't work, I'm sure there would be a way to address that too
regards, barry