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
=IF(ISBLANK(A1);"";MIN(500;A1*A2))

Thanks,
FoxalTO
 
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

Hi..

I have a Alternative suggestion please try it:
Code: Select all
=if(or(isblank(A1);isblank(A2));"";min(500;A1*A2))

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


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 2 guests

cron