Hi,

I am trying to work out a way to set a default value for a cell if the value
from a formula returned is too low.

For example: I am using a very basic formula to calculate square metres from
panel dimensions and the another formula to calculate the cost to paint these
panels.

Sometimes the panels are quite small and the value returned in the cost
column becomes artificially low (even though the formula is working correctly
the value shown will not cover my labour costs.)

Therefore I need excel to look at the formulated value and if it is below,
lets say 20, then it would automatically return a value of 20.

Hoping someone can help me with this problem.

Thank-you.