Problem with IF function
 

Thank you in advance for your help. I'm just learning about functions and am
stuck on how to achieve the following "IF/THEN" scenario:

Cell A1: $100
Cell B1: 21%
Cell C1: $200

Cell D1 will contain the formula:

I need a function where the value found in A1 ($100) will be displayed IF B1
is larger than 30%. If it's not larger, display the value in C1 ($200).

Also, how would this change if the 30% is a value that I want to globally
change (I've created a defined name of "Value_Percentage")

Thanks for the shove in the right direction. Much appreciated!

Problem with IF function
 

=IF(B10.3,A1,C1)

What you could do with the % item you mention is have cell b1 (and all
others that would contain it) refer to another cell that contains the global
value you want to apply. For example if the global value was in cell F1 then
B1 would have =$F$1 in place of the static value.

--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"FrozenRope" wrote:

Thank you in advance for your help. I'm just learning about functions and am
stuck on how to achieve the following "IF/THEN" scenario:

Cell A1: $100
Cell B1: 21%
Cell C1: $200

Cell D1 will contain the formula:

I need a function where the value found in A1 ($100) will be displayed IF B1
is larger than 30%. If it's not larger, display the value in C1 ($200).

Also, how would this change if the 30% is a value that I want to globally
change (I've created a defined name of "Value_Percentage")

Thanks for the shove in the right direction. Much appreciated!

Problem with IF function
 

Hi,

Try

=IF(B1Value_Percentage,A1,C1)

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"FrozenRope" wrote:

Thank you in advance for your help. I'm just learning about functions and am
stuck on how to achieve the following "IF/THEN" scenario:

Cell A1: $100
Cell B1: 21%
Cell C1: $200

Cell D1 will contain the formula:

I need a function where the value found in A1 ($100) will be displayed IF B1
is larger than 30%. If it's not larger, display the value in C1 ($200).

Also, how would this change if the 30% is a value that I want to globally
change (I've created a defined name of "Value_Percentage")

Thanks for the shove in the right direction. Much appreciated!

Problem with IF function
 

Try not to double-post



"FrozenRope" wrote:

Thank you in advance for your help. I'm just learning about functions and am
stuck on how to achieve the following "IF/THEN" scenario:

Cell A1: $100
Cell B1: 21%
Cell C1: $200

Cell D1 will contain the formula:

I need a function where the value found in A1 ($100) will be displayed IF B1
is larger than 30%. If it's not larger, display the value in C1 ($200).

Also, how would this change if the 30% is a value that I want to globally
change (I've created a defined name of "Value_Percentage")

Thanks for the shove in the right direction. Much appreciated!