Don't want to re-type formula

Is there a way to do this:

=IF(A1+B1<0,0,A1+B1), with out having to re-type the formula for the [value_if_false] area?

Thanks!

If I understand your question, the formula as presented works already.

Please Login or Register  to view this content.

Or, what am I missing in your question ?

=max(0, a1+b1)

Thank you for responding so quickly!

The formula works just fine, I was just wondering if there was a different way to type it. This is just an example of how I use the formula. Most of the time it's not A1+B1, but rather a longer fmla. At current time, I just use Ctrl-C , Ctrl-V, but, as mentioned above, I was curious as if there was a differnt way to do it.

Cheers!

Thank you!

This works great for this case, but what if I'm not making a mathemathical answer? Let's say my fmla is:

=IF(VLOOKUP(A1,PAGE1!A:Q,4,0)<>"TEXAS","NOT TX",VLOOKUP(A1,PAGE1!A:Q,4,0))

I don't need a specific answer to the formula, just a way (shortcut, other than Ctrl-C/V) so I can avoid typing the second "VLOOKUP(A1,PAGE1!A:Q,4,0)".