Search : in
By :

Hiding a cell if value equals X

Last answer on Jul 22, 2009 6:28:47 am BST Aimee, on Jul 20, 2009 1:37:25 pm BST 
 Report this message to moderators

Hello,

I want to do the following in EXCEL.

I have a formula which works out the cost of one item at $35 plus adds $3.8 per item thereafter. Tf the cell i am putting my equation in is D5 and the cell with the quantity of items is C5 then my equation would look as follows.

D5 = 35+((C5-1)*3.8)

So if C5 = 1 then the answer is $35 which is correct
and if C5 = 2 then the answer is $38.80
BUT if C5 = 0 then I want the cell to display Zero???? ANY IDEAS?

Configuration: Windows XP
Firefox 3.0.11

Best answers for « Hiding a cell if value equals X » in :
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
VB6 Finding the RGB values of a color ShowVB6 Finding the RGB values of a color Dim R as integer Dim G as integer Dim B as integer Sub FindRGB(Col As Long) R = &HFF& And Col G = (&HFF00& And Col ) \ 256 B = (&HFF0000 And Col ) \ 65536 End Sub Note: Here...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Ask your question Reply

1

Trowa, on Jul 20, 2009 1:50:57 pm BST

Hello Aimee,

Use the IF function:

=IF(35+((C5-1)*3,8)<35;0;35+((C5-1)*3,8))

If the result of your formula is smaller then 35 then display a 0,
If the result of your formula is the same or bigger then 35 then display the result of your formula.

Hope this is what you were looking for.

Best regards,
Trowa

   
Reply to Trowa

2

Aimee, on Jul 22, 2009 5:45:57 am BST

Hi Trowa,

Thanks for your help! New it would need an IF formula but had no clue how to word it!

Yours looks like it should work, but when I try type it in excel it gives me an error saying that "The formula you typed contains an error" any ideas on why?

Really hope you can help!

Aimee

   
Reply to Aimee

3

Aimee, on Jul 22, 2009 6:24:43 am BST

Sorry,

Tried it again and it does work!

Thanks a million!

   
Reply to Aimee

4

 Aimee, on Jul 22, 2009 6:28:47 am BST

Hi Trowa,

Worked out what was wrong, in your formula you had ; where it should of been , !

So happy to finally have the answer to this! You are a lifesaver!

   
Reply to Aimee
Ask your question Reply
They need your help