Formula help Please!!!

CAPT.PT · May 16th, 2002, 01:22 PM

I need to write in a cell the figures that were used in differant worksheets...as a formula..please don't ask why..anyway it needs to show this info:
if O12>0, then print what #is in cell from Daily Log AE7, times what # is in Worksheet D7, then show that equals the # in "payroll Input" O7

the out come should read in the cell:

24 * 14.18 = 340.32

those are the numbers in those certain cells
Thank you very much!

Aladin Akyurek · May 16th, 2002, 01:28 PM

Quote:

On 2002-05-16 12:22, CAPT.PT wrote:
I need to write in a cell the figures that were used in differant worksheets...as a formula..please don't ask why..anyway it needs to show this info:
if O12>0, then print what #is in cell from Daily Log AE7, times what # is in Worksheet D7, then show that equals the # in "payroll Input" O7

the out come should read in the cell:

24 * 14.18 = 340.32

those are the numbers in those certain cells
Thank you very much!

=IF(O12,'Daily Log'!A7&" * "&D7&" = "&'Payroll Input'!O7,"")

I interpreted the "in Worksheet D7" bit as simply D7.

If O12 is 0, you get a blank [""] as result.

Yogi Anand · May 16th, 2002, 01:35 PM

use the following formula -- adjusting the sheet numbers according to your setup ...

=IF(SheetWhich1!O12>0,SheetWhich2!AE7*SheetWhich3!D7,"")

Regards!

May 16th, 2002, 01:35 PM	#3
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	use the following formula -- adjusting the sheet numbers according to your setup ... =IF(SheetWhich1!O12>0,SheetWhich2!AE7*SheetWhich3!D7,"") Regards! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 01:22 PM	#1
CAPT.PT New Member Join Date: Mar 2002 Posts: 32	I need to write in a cell the figures that were used in differant worksheets...as a formula..please don't ask why..anyway it needs to show this info: if O12>0, then print what #is in cell from Daily Log AE7, times what # is in Worksheet D7, then show that equals the # in "payroll Input" O7 the out come should read in the cell: 24 * 14.18 = 340.32 those are the numbers in those certain cells Thank you very much!