+ Start a Discussion
Leyadk DevelLeyadk Devel 

Formula Help Requested

Hi guys,

 

I need to write a couple of formulas. I have two currency fields which I would like to make the value for into formulas:

 

1. Total Value of Savings Suggested

2. Total Value of Savings Implemented

 

I have 5 currency fields:

 

Value of Saving Initiative 1

Value of Saving Initiative 2

Value of Saving Initiative 3

Value of Saving Initiative 4

Value of Saving Initiative 5

 

Each has a corresponding checkbox - initiative implemented? If ticked, the saving has been implemented and if not it is suggested.

 

Thus I need to make my formulas dependent upon each of the checkboxes.

 

Please could anyone help with the writing of these formulas?

 

Many thanks,

Dave

STest123STest123

i think this is not possible.

Vz123Vz123

You could give a below try for the formula, though it will be length one:

 

FieldCheckbox

---------------------------------------

f1c1

f2c2

f3c3

Savings Implemented= IF( AND(c1=true,c2=true,c3=true), f1+f2+f3,

if(AND(c2=true,c3=true), f2+f3,

if(AND(c1=true,c3=true), f1+f3,

if(AND(c2=true,c3=true), f2+f3,

if(c2=true, f2,

if(c3=true,f3,

if(c1=true,f1,0))))))

and the other way check for  Savings Suggested  = if C1 = false, f2...

 

Thanks