| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning a zero
I have a worksheet with 2 sheets. The first sheet has all formulas and
depends on the second sheet. I need a formula in sheet 1 that subtracts cell a1 from cell b1 but if cell a1 is zero I want the formula to return a zero. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Returning a zero
Certainly. Use something like:
=if(sheet2!a1=0,0,sheet2!b1-sheet2!a1) Regards, Fred. "Dena" wrote in message ... I have a worksheet with 2 sheets. The first sheet has all formulas and depends on the second sheet. I need a formula in sheet 1 that subtracts cell a1 from cell b1 but if cell a1 is zero I want the formula to return a zero. Is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Returning a zero
Thank you!
"Fred Smith" wrote: Certainly. Use something like: =if(sheet2!a1=0,0,sheet2!b1-sheet2!a1) Regards, Fred. "Dena" wrote in message ... I have a worksheet with 2 sheets. The first sheet has all formulas and depends on the second sheet. I need a formula in sheet 1 that subtracts cell a1 from cell b1 but if cell a1 is zero I want the formula to return a zero. Is this possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Returning a zero
You're welcome. Thanks for the feedback.
Regards, Fred "Dena" wrote in message ... Thank you! "Fred Smith" wrote: Certainly. Use something like: =if(sheet2!a1=0,0,sheet2!b1-sheet2!a1) Regards, Fred. "Dena" wrote in message ... I have a worksheet with 2 sheets. The first sheet has all formulas and depends on the second sheet. I need a formula in sheet 1 that subtracts cell a1 from cell b1 but if cell a1 is zero I want the formula to return a zero. Is this possible? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Returning a zero
=IF(A1=0,0,B1-A1)
"Dena" wrote: I have a worksheet with 2 sheets. The first sheet has all formulas and depends on the second sheet. I need a formula in sheet 1 that subtracts cell a1 from cell b1 but if cell a1 is zero I want the formula to return a zero. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDF from Add-In returning #NAME | Excel Worksheet Functions | |||
| Returning #N/A | Excel Discussion (Misc queries) | |||
| Returning a 0 Value | Excel Worksheet Functions | |||
| Need some help returning a value | Excel Worksheet Functions | |||
| Returning more than one value | Excel Discussion (Misc queries) | |||
Hybrid Mode
