Previous Topic Next Topic

Help! new to excell

Closed
mike - Feb 9, 2010 at 03:39 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2010 at 03:46 PM
Hello,
i have an excell spread sheet with multipule sheets open. i need to select certain rows of information, copy the info and tell that information where to appear on another sheet or multipule sheets.
i was trying the if command. =if g4>0,"a4:d4", which gets me the info i need but how do i tell it to go to another
cell in another sheet?

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2010 at 03:46 PM
I am not too sure what you want but it seems to me what you need is to make the call in the other sheet to check the value and if condition passes, show the value

some thing like

=if('Shee1'!g4> 0, 'sheet1!g4, "")
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response