Help with a formula !

General discussion on OpenOffice Calc and its spreadsheets.

Help with a formula !

Postby Elwood M. Walker » Sat Sep 06, 2014 5:00 am

Hello everybody,

I need some help with a formula. I want to multiply the values of the 2 fields, let's say fields A1 and A2, but there are couple of condition. If the total of the multiplied values exceeds certain value, let's say 500, then the result must be 500. Also, if the fields A1 and A2 are empty with no values, then this field should also be blank.

Thanks in advance,
Elwood M. Walker
Posts: 33
Joined: Mon Mar 24, 2014 6:09 am

Re: Help with a formula !

Postby FoxalTO » Fri Sep 12, 2014 4:45 am

Hello everyone,

Please Assuming that if A1 is blank, so is A2
Code: Select all

Posts: 26
Joined: Tue Mar 25, 2014 6:25 am

Re: Help with a formula !

Postby Micheal T. Leo » Fri Sep 12, 2014 7:45 am


I have a Alternative suggestion please try it:
Code: Select all

Micheal T. Leo
Posts: 26
Joined: Mon Mar 24, 2014 6:26 am

Return to Calc

Who is online

Users browsing this forum: No registered users and 0 guests