When multiplying two cells, i only want the answer displayed if it's above a certain number

[brianaclark1967]

Hi,

I've added a simple sheet.

When the two cells shown are multiplied, i only want the answer to show in the results cell if it is 133 or above.

If the answer is below 133, I want the result cell to show 133.

Any hints guys?

Regards

Brian

 

[NARAYANK991]

Hi Brian ,

Use the formula :

=MAX(133,B4*D4)

Narayan

 

[brianaclark1967]

Thanks Narayan,

You're a star

Regards

Brian

 

[brianaclark1967]

Hi,

I've uploaded a simple test sheet.

If I have two cells that multiply to give me a square metre result.

It the answer is less than 1m2 the default answer of £133 is inserted.

If the answer is greater than 1.0 m2, it multiplies the answer by £133

Many thanks

Brian

 

[Somendra Misra]

Hi Brian,

Shouldn't the formula in your file in cell F4 should be
=MAX(1,B4*D4)*133

as advised by @NARAYANK991 Sir ?

Regards,

 

[brianaclark1967]

Hi Brian,

Shouldn't the formula in your file in cell F4 should be
=MAX(1,B4*D4)*133

as advised by @NARAYANK991 Sir ?

Regards,

Many thanks for your help.

Much appreciated.

Regards

Brian