Could you please help me with formula shown in the attached excel file. I showed the result I want and wrote text "Formula" in cell so that specific formula help to multiply mentioned figures.
Could you please help me with formula shown in the attached excel file. I showed the result I want and wrote text "Formula" in cell so that specific formula help to multiply mentioned figures.
Use
=H$8*$G9
Or use
=IF(ROW(A1)=COLUMN(A1),H$8*$G9,"")
in H9
=H$8*$G9 It doesn work
Hi
see the file formula for multiply.xlsx
Could we use the same multiply formula in H19 but without sum, and drag right to get the same value
Yes, you can use in H22
=OFFSET(G8,COLUMN(A1),1)
Formula:Please Login or Register to view this content.
see the file formula for multiply (1).xlsx
Regards
Perfect. Thank you for your patience, effort and help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks